MySQL Forums
Forum List  »  Quality Assurance

Re: Where clause doesn't work! Is this a bug?
Posted by: Han Joosten
Date: January 22, 2018 01:01PM

Well, I have MySQL 5.7.18 running, the bug is in it (otherwise I wouldn't have run into it in the first place). Doing some search, In the releasenotes I found:

Queries that contained UNION in a subquery and GROUP BY could return incorrect results. (Bug #24595639)

However, I was unable to find more about when it was solved precisely. I am glad it is solved in newer versions!

Thanks for the quick response, and also for the advise about casing. I'll build it in into our generator.

Options: ReplyQuote

Written By
Re: Where clause doesn't work! Is this a bug?
January 22, 2018 01:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.