Does a NULL row survive NOT IN?

Question

Accepted Answer

For the NULL row, `NULL NOT IN (1, 2, 3)` expands to `NULL != 1 AND NULL != 2 AND NULL != 3`. Every comparison with NULL is UNKNOWN, so the whole expression is UNKNOWN - that row is excluded. For v = 7, all three comparisons are TRUE, so 7 passes. The NULL row quietly disappears even though the list contains no NULL.