SQL NULL Pitfalls: Why NOT IN Returns Zero Results and 3 Points Where MySQL and Oracle Behaviors Diverge

Introduction"I want to list customers who haven't ordered, but I get zero results," or "The count doesn't match when I ...

The story of how Lua's 0/1 comparison failed with TINYINT(1) in oxmysql

In my server's scripts, when I compared DB values using == 1, the conditions stopped working. The cause was that the ...