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 🙂
Today, this clause was returning no results. I had to change the clause to
WHERE `Date` = DATE_SUB(CURDATE(), INTERVAL 1 DAY)
Using CURDATE()-1 still seems to work in beastmodes. Just not in my MySQL dataflow
select version() or select @@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...
this is what I get for select version()
Yeah so still same version as ever. It's unlikely that it was due to a glitch in MySQL...