Re: Where clause doesn't work! Is this a bug?
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.
Subject
Views
Written By
Posted
1659
January 21, 2018 05:08AM
849
January 21, 2018 11:13AM
817
January 22, 2018 04:32AM
911
January 22, 2018 11:05AM
Re: Where clause doesn't work! Is this a bug?
941
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.