From Dev.to
The SQL NOT IN Trap: When NULL Quietly Breaks Your Query
Some SQL bugs don't throw errors. The query runs, the tests pass, and everything looks fine until a cleanup job skips records it was supposed to catch. One of the reasons this happens is NULL inside a...