ss - oscar

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

  • 1

Log in