| Bug #24778 | Innodb: No result when using ORDER BY | ||
|---|---|---|---|
| Submitted: | 2 Dec 2006 17:17 | Modified: | 24 Apr 2007 2:58 |
| Reporter: | Christian Hammers (Silver Quality Contributor) (SCA) | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S2 (Serious) |
| Version: | 5.0.32-BK, 5.0.27 | OS: | Linux (Debian GNU/Linux Sid) |
| Assigned to: | Martin Hansson | Target Version: | |
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-24778.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.
[2 Dec 2006 17:18]
Christian Hammers
[2 Dec 2006 17:18]
Christian Hammers
Queries
Attachment: t.select (application/octet-stream, text), 453 bytes.
[6 Feb 2007 9:49]
Martin Hansson
A (more) minimal schema and data to reveal the bug.
Attachment: initial-build.mini.sql (text/x-sql), 1.88 KiB.
[6 Feb 2007 9:50]
Martin Hansson
A (more) minimal query to go with the minimized schema.
Attachment: t.select.mini.sql (text/x-sql), 344 bytes.
[20 Mar 2007 9:47]
Martin Hansson
This is alternative fix for the bug that allows for sorting on any table in the plab
Attachment: test_if_skip_sort_order.patch (text/x-patch), 828 bytes.
