SQLite Forum

Unexpected return from the NULL column
This will always be False thus the result will always be no rows.

WHERE NULL NOT IN ( SELECT count ( * ) FROM v0);

`WHERE x IN (a,b,c,d,...z)`  
`x == a or x == b or x == c or x == d or ... x == z`  

However, if the value of x is null (as in this case) then no matter what there is no value of `a` that can make NULL == a evaluate true, because all operations against null have a null result (or false, if in the where clause).

sqlite> select null in (null);
│ null in (null) │
│                │