Bug #90817 | FORCE INDEX doesn't take effect when a query has group_by, order_by, and limit | ||
---|---|---|---|
Submitted: | 10 May 2018 1:24 | Modified: | 12 Jun 2018 14:57 |
Reporter: | Shu Lin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.6.40 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[10 May 2018 1:24]
Shu Lin
[10 May 2018 8:03]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[12 Jun 2018 14:57]
Jon Stephens
Documented fix as follows in the MySQL 5.6.41 changelog: FORCE INDEX had no effect on a query that used GROUP BY, ORDER BY, and LIMIT together. Closed.