On 2017/09/06 11:37 PM, Cecil Westerhof wrote:
But should in the first case the 0 not be cast to a 0.0?
What makes you believe SQLite should massage the data into specific
types for you without you requesting it explicitly?
In fact, that would consume valuable extra CPU cycles and would
definitely make most of us unhappy.
Your CHECK constraint should really find that the value is acceptable
when it is either a REAL, OR an INT, because both those types of data
satisfies your requirement.
sqlite-users mailing list