News for hackers. Stuff that matters.
Re:Things in MySQL that won't work as expected by jerf on Sunday November 07, 2010 @10:24PM (#1881249)
Or possibly the NULL should behave more like a modern NULL and have a different truth table for it. I don't think it is coincidence that no modern NULL value in a programming language acts like the SQL NULL.

People will usually reply to my criticisms about SQL NULL by pointing out that it is logically consistent, which is true, but it's not the only logically consistent NULL we can define. I know the theory behind the SQL NULL quite well, well enough to observe just how rarely it matches SQL practice.

Re:Things in MySQL that won't work as expected by saurik on Monday November 08, 2010 @12:14AM (#1881478)
(I personally find the SQL null semantics incredibly clear and understandable, and find the weird hacks many languages take to have null mean something really confusing.)