WHERE section gets messed up

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
eried
Posts: 1
Joined: Wed 09 Sep 2020 11:02

WHERE section gets messed up

Post by eried » Wed 09 Sep 2020 11:08

I have the following WHERE:

Code: Select all

    WHERE YEAR(entries.timestamp) = YEAR(CURRENT_DATE()) AND MONTH(entries.timestamp) = MONTH(CURRENT_DATE())
If I do anything on the query builder, this gets rewritten to:

Code: Select all

WHERE YEAR(CURRENT_DATE(), MONTH(entries.timestamp) = MONTH(CURRENT_DATE()))
Which is not right. Why?

alexa
Devart Team
Posts: 2889
Joined: Fri 24 Jun 2011 14:17

Re: WHERE section gets messed up

Post by alexa » Wed 09 Sep 2020 20:23

We will fix it in one of the next product builds.

Post Reply