Bug #35061 order by returns unsorted results with limit and force index
Submitted: 5 Mar 2008 2:25 Modified: 6 Mar 2008 6:43
Reporter: r b Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.0.50a OS:Linux
Assigned to: CPU Architecture:Any
Tags: force index, limit, order by

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[5 Mar 2008 2:27] r b
repro for this bug

Attachment: MySQLSortBugRepro.txt (text/plain), 8.30 KiB.