Re: Bug in SQLite version 3.31.1 and 3.32?
Peter da Silva <[email protected]> Fri, 6 Mar 2020 20:00:31 -0600
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
> If I change IS NOT FALSE to IS TRUE, the results will be different. I > assume they should perform in the same way? > if you say "NULL IS NOT FALSE" is always true, then 'NULL IS TRUE' should > also be always true. "NULL IS NOT FALSE" is true because NULL is not a value therefor it is not FALSE, because FALSE is a value. "NULL IS TRUE" is false because NULL is not a value so it's not TRUE. You can't compare NULL with anything. All you can do is tell if it "IS NULL" or "IS NOT NULL". _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users