Change in MySQL calculations

ST_-Superman-_

Has anyone else noticed that your MySQL dataflows started to evaluate expressions differently?

 

Yesterday, I was using this where clause to filter for yesterday's date and it was working

WHERE `Date` = CURDATE()-1

Admittedly, this is a lazy way of doing it... but, well... coders are lazy

jaeW_at_Onyx

@version will tell you the MySQL version number.

 

As long as it's still 5.6 (i believe) then the version of SQL didn't change and it's unlikely the problem was a change in MySql...

ST_-Superman-_

this is what I get for select version()

 

5.6.28-76.1-56

 

 

jaeW_at_Onyx

Yeah so still same version as ever.  It's unlikely that it was due to a glitch in MySQL...