IS DISTINCT FROM: Comparing NULLs Without the Headache

· by · in

It usually shows up in a code review. Someone writes a filter that is supposed to exclude voided rows, it looks completely reasonable, and yet a tester swears that records are going missing. The query…