SQLite Forum

"is true" is not actually an operator -> correctness bugs
Login

"is true" is not actually an operator -> correctness bugs

(1) By Rico Mariani (rmariani) on 2021-07-22 20:05:44 [source]

sqlite> select false is true < false;
1
sqlite> select sqlite_version();
3.32.3

vs.

PostgreSQL> select false is true < false;
false

PostgreSQL> select version();
PostgreSQL 9.6.17 on x86_64-pc-linux-gnu (Debian 9.6.17-2.pgdg90+1), compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit

Other SQLs also seem to treat IS TRUE (and IS FALSE) as a two-word operator not a modified IS.

This began as an issue with the documents here but I believe there are actual bugs so I started a separate thread to discuss correctness.