This is a quote from the MySql Manual:

The NULL value can be surprising until you get used to it.

And yes, the documentation is right. Yesterday we encountered a strange bug on a project at Gameforge because of a wrong sql statement. Here is what happened.