Change in MySQL calculations

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

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @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()

    Β 

    5.6.28-76.1-56

    Β 

    Β 

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

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