SQLite Forum

Unexpected return from the NULL column
Login
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)`  
means  
`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) │
├────────────────┤
│                │
└────────────────┘
```