Bug #7516 Wrong sort order when ORDER BY includes an ENUM column
Submitted: 23 Dec 2004 21:26 Modified: 26 Nov 2005 14:02
Reporter: Andrei Nazarenko
Status: Can't repeat
Category:Server: Optimizer Severity:S2 (Serious)
Version:4.0.25 and 4.1.10a OS:Linux (Linux (SuSE 8.2))
Assigned to: Target Version:

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-7516.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[10 Feb 2005 19: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 23: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 1: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 17:19] Andrei Nazarenko 
A trace file obtained during the failing query

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