Which fix removes the bug?
SELECT name FROM users WHERE email = NULL; -- expected: users without an email
- Write
email == NULL - Write
email IS NULL - Write
email = 'NULL' - Write
email <> NULL
Any comparison with NULL using = is unknown, never true; IS NULL is the test for missing values.
Play Problem Solving ▸