Bug #82334 | unexpected order for grouped query | ||
---|---|---|---|
Submitted: | 25 Jul 2016 10:58 | Modified: | 16 Dec 2016 14:00 |
Reporter: | Tobias Weber | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
Version: | 5.7.13 | OS: | CentOS |
Assigned to: | CPU Architecture: | Any | |
Tags: | regression |
[25 Jul 2016 10:58]
Tobias Weber
[25 Jul 2016 11:04]
Tobias Weber
Statement with DESC as sort direction results in same like with ASC
[25 Jul 2016 11:13]
MySQL Verification Team
Hello Tobias, Thank you for the report and test case. Thanks, Umesh
[15 Aug 2016 5:47]
Gillian Gunson
This looks like a duplicate of this bug: https://bugs.mysql.com/bug.php?id=79366 ("ORDER BY does not work correctly with grouped AVG() values extracted from JSON" -- misleading title as it's not a JSON issue) The culprit is the AVG() aggregation plus the TEXT column. It works fine with SUM(), for example, and/or with VARCHAR in my testing.
[16 Dec 2016 13:59]
Tobias Weber
Bug was fixed in 5.17.7
[16 Dec 2016 14:00]
Tobias Weber
5.7.17...