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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
