On 3/23/18, David Raymond <[email protected]> wrote: > > sqlite> create table foo (true boolean); > > sqlite> insert into foo (true) values (false); >
Then you get a non-empty set from: SELECT * FROM foo WHERE true IS false; Moral: Don't use identifiers "true" or "false" as column names. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
