On May 5, 2014, at 8:00 PM, Richard Hipp <d...@sqlite.org> wrote: > Petite's complaint is that in most other SQL database engines, 0 is not > false. If you try to use 0 where a boolean is needed, you get a syntax > error. In strict SQL, boolean and integer are incompatible types that > cannot be interchanged.
While I do agree with the above, this not about types per se. And it’s not about the meaning of life, nor metaphysics. I simply wish the *SQL* parser was more strict about what it accepts. My point is that blindly accepting a bare expression as a comparison fails far short of both ‘simplicity’ and ‘sanity'. That’s all. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users