Re: Bug in SQLite version 3.31.1 and 3.32?
Xinyue Chen <[email protected]> Fri, 6 Mar 2020 17:52:50 -0800
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAN9D1=Res9iCfMGFa80HdkxacNpz1dEs4QHjD3Xd0Hs-vPDn1Q@mail.gmail.com> |
Hi, 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. Then why doesn't that query also return 4 rows? Thanks! On Fri, Mar 6, 2020 at 5:45 PM Peter da Silva <[email protected]> wrote: > Change the "(t1.textid = null)" to "(t1.textid IS NULL)". Null has no > value, you have to check for it explicitly. > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users