Oracle quirks: Comparing NULL
Our Oracle database just keeps amazing me. Given the following testcase: SELECT CASE WHEN NULL = '' THEN 1 ELSE 0 END as nullvsemptystring, CASE WHEN NULL = NULL THEN 1 ELSE 0 END as nullvsnull, CASE WHEN NULL = 'asdf' THEN 1 ELSE 0 END as nullvsstring FROM DUAL Expected: nullvsemptystring -…