My SQL Dump

MySQL musings by a self professed MySQL Geek


  • 1
This kind of thing doesn't surprise me at all. I recently ran into a bug with NULL-safe checks against DATE/DATETIME fields but only on the right side of the operand. The workaround was to cast the date field to CHAR(10). Wheee....

IF (NOT (OLD.some_date <=> CAST(NEW.some_date AS CHAR(10)))) THEN

http://bugs.mysql.com/bug.php?id=36100
http://bugs.mysql.com/bug.php?id=40247

  • 1
?

Log in