Bug #76947 | Single-table scalar subquery with LIMIT and ORDER BY gives wrong results | ||
---|---|---|---|
Submitted: | 6 May 2015 7:31 | Modified: | 13 Jul 2015 13:43 |
Reporter: | Guilhem Bichot | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
Version: | 5.6.25 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 May 2015 7:31]
Guilhem Bichot
[13 Jul 2015 13:43]
Paul DuBois
Noted in 5.7.8, 5.8.0 changelogs. If a single-table subquery had identical GROUP BY and ORDER BY clauses on a UNIQUE NOT NULL column, the results could be incorrectly ordered.