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: | |
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 |
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[10 Feb 2005 18:29]
Andrei Nazarenko
[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.