Posted to tcl by aspect at Wed Mar 20 12:52:49 GMT 2019view raw
- $ 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