Change in MySQL calculations

ST_Superman
ST_Superman Domo Employee
in Magic ETL

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 Coach

    @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...

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • ST_Superman
    ST_Superman Domo Employee

    this is what I get for select version()

     

    5.6.28-76.1-56

     

     

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

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

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories