"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
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.