Bug #67958 IMPORTANT! MySQL Server 5.5.29(28) wrong sorting using complex index
Submitted: 21 Dec 2012 12:53 Modified: 18 Jan 2013 11:14
Reporter: Alexander Egelsky Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S1 (Critical)
Version:5.5.29, 5.5.28 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.5.29, 5.5.29, bug, core, INDEX, order by, sorting

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:

[21 Dec 2012 12:54] Alexander Egelsky
Schema to reproduce

Attachment: __schema_5.5.29_bug.sql (application/octet-stream, text), 900 bytes.

[21 Dec 2012 12:55] Alexander Egelsky
Query which should return 525

Attachment: __query_5.5.29_bug.sql (application/octet-stream, text), 422 bytes.