SQLite Forum

operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors
Login
> Well it turns out that "is false" and "is not false" do not need to be special

SQLite version 3.36.0 2021-06-18 18:36:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select '' is false;
1
sqlite> select '' is (false);
1
sqlite> select '' is (+false);
0
sqlite> select false;
0
sqlite> select '' is 0;
0
sqlite> select '' is (0);
0
sqlite> select '' is (+0);
0