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

  1. $ sqlite3
  2.  
  3. sqlite> .nullvalue NULL
  4.  
  5. sqlite> select 1 in (1);
  6. 1
  7.  
  8. sqlite> select 1 not in (1);
  9. 0
  10.  
  11. sqlite> select 1 in (2);
  12. 0
  13.  
  14. sqlite> select 1 not in (2);
  15. 1
  16.  
  17. sqlite> select 1 in (null);
  18. NULL
  19.  
  20. sqlite> select 1 not in (null);
  21. NULL
  22.