On 3/23/18, David Raymond <david.raym...@tomtom.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
