Change in MySQL calculations

ST_-Superman-_
ST_-Superman-_ 🟤
in Dataflows

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


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________

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


    Jae Wilson
    Check out my Domo Training YouTube Channel

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • ST_-Superman-_
    ST_-Superman-_ 🟤

    this is what I get for select version()

     

    5.6.28-76.1-56

     

     


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • 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...


    Jae Wilson
    Check out my Domo Training YouTube Channel

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

Categories