Posted to tcl by aspect at Wed Mar 20 12:52:49 GMT 2019view pretty

$ sqlite3

sqlite> .nullvalue NULL

sqlite> select 1 in (1);
1

sqlite> select 1 not in (1);
0

sqlite> select 1 in (2);
0

sqlite> select 1 not in (2);
1

sqlite> select 1 in (null);
NULL

sqlite> select 1 not in (null);
NULL