Bug #7516 Wrong sort order when ORDER BY includes an ENUM column
Submitted: 23 Dec 2004 20:26 Modified: 26 Nov 2005 13:02
Reporter: Andrei Nazarenko Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:4.0.25 and 4.1.10a OS:Linux (Linux (SuSE 8.2))
Assigned to: CPU Architecture:Any

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:

[10 Feb 2005 18:29] Andrei Nazarenko
This is a dump to demonstrate the ORDER BY ENUM

Attachment: testcase.sql.gz (application/x-gzip, text), 5.38 KiB.

[11 Feb 2005 22:46] Andrei Nazarenko
This is a testcase SQL which is ZIP'd instead of GZIP'd

Attachment: testcase.sql.zip (application/zip, text), 5.33 KiB.

[12 Feb 2005 0:08] Andrei Nazarenko
Result dumps as described in comment from the 10th February

Attachment: results_output.zip (application/x-zip-compressed, text), 12.72 KiB.

[15 Feb 2005 16:19] Andrei Nazarenko
A trace file obtained during the failing query

Attachment: mysqld.trace.zip (application/zip, text), 26.80 KiB.