Bug #45095 | order by not using index | ||
---|---|---|---|
Submitted: | 26 May 2009 11:18 | Modified: | 29 Nov 2009 0:05 |
Reporter: | Bogdan Kecman | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.1.32, 4.1, 5.0, 5.1, 6.0 bzr | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[26 May 2009 11:18]
Bogdan Kecman
[26 May 2009 20:13]
Sveta Smirnova
Thank you for the report. Verified as described. Looks like duplicate of bug #35334, but "select * from t1 order by orderby;" uses filesort for InnoDB as well since version 5.1.
[26 May 2009 20:14]
Sveta Smirnova
test case for the testsuite
Attachment: bug45095.test (application/octet-stream, text), 1.05 KiB.
[28 Sep 2009 18:08]
Susanne Ebrecht
Bogdan, what is up now here?
[29 Oct 2009 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[30 Nov 2009 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".