Bug #2419 | ORDER BY ignore rows | ||
---|---|---|---|
Submitted: | 16 Jan 2004 1:32 | Modified: | 3 Feb 2004 5:47 |
Reporter: | Javier Tacón | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.1.1 & 5.0.0 | OS: | Linux (Linux Red Hat 7.3) |
Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
[16 Jan 2004 1:32]
Javier Tacón
[16 Jan 2004 8:03]
Dean Ellis
Verified with 4.1.2. Thank you for the report.
[30 Jan 2004 8:50]
MySQL Verification Team
An additional test case ... drop table if exists t1; CREATE TABLE t1 ( Id INTEGER NOT NULL, Id2 INTEGER NOT NULL, Val FLOAT NOT NULL, Id3 INTEGER NOT NULL, KEY Key2 (Id2, Val), KEY Key3 (Id3)); INSERT INTO t1 VALUES(1,3,-12,4); INSERT INTO t1 VALUES(2,2,-27.5,4); INSERT INTO t1 VALUES(3,2,18.4,3); SELECT Id3 FROM t1 WHERE Id2=2 AND Val BETWEEN -30 AND 20; SELECT Id3 FROM t1 WHERE Id2=2 AND Val BETWEEN -30 AND 20 ORDER BY Id3; drop table if exists t1;
[3 Feb 2004 5:47]
Ramil Kalimullin
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html