3 ms·
That would be sensible if SQL dialects usually offered a sane comparison that returns true/false reasonably for null comparisons. Since they don't, and = is th
by Pxtl 11y ago
That would be sensible if SQL dialects usually offered a sane comparison that returns true/false reasonably for null comparisons. Since they don't, and = is the only available equality test, I'm going to stick to my original point that null comparison in SQL is dumb and wrong for 99% of use-cases and compiler warnings would be solving the wrong problem.
- dllthomas 11y agoMySql, Postgres, and Vertica, at least, all support <=> as an operator that treats NULL as an ordinary, distinct value.