Re: MySQL 5.5.8 - Configuration Settings Suggestions

[Rick James]

Looks bad to me:

mysql> SELECT NULL IN (1, NULL), 2 IN (1, NULL);
+-------------------+----------------+
| NULL IN (1, NULL) | 2 IN (1, NULL) |
+-------------------+----------------+
|              NULL |           NULL |
+-------------------+----------------+

NULL IN NULL fails, so you can't really test for it in an IN clause.