Bug #2865 | Error with Order By and Limit 1 | ||
---|---|---|---|
Submitted: | 18 Feb 2004 5:43 | Modified: | 18 Feb 2004 8:09 |
Reporter: | Andre Justus | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 4.1.1 | OS: | Linux (Linux Debian 3) |
Assigned to: | CPU Architecture: | Any |
[18 Feb 2004 5:43]
Andre Justus
[18 Feb 2004 8:09]
Alexander Keremidarski
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. Additional info: mysql> SELECT * -> FROM `arenenregulator` -> WHERE offen <6 -> ORDER BY arena ASC -> LIMIT 1; +-------+-----------+-------+ | arena | startwert | offen | +-------+-----------+-------+ | 2 | 0 | 0 | +-------+-----------+-------+ 1 row in set (0.00 sec) mysql> SELECT * -> FROM `arenenregulator` -> WHERE offen <6 -> ORDER BY arena ASC; +-------+-----------+-------+ | arena | startwert | offen | +-------+-----------+-------+ | 2 | 0 | 0 | | 3 | 0 | 0 | | 4 | 0 | 0 | | 5 | 0 | 0 | | 6 | 0 | 0 | +-------+-----------+-------+ 5 rows in set (0.00 sec) mysql> SELECT * -> FROM `arenenregulator` -> WHERE offen <6 -> ORDER BY arena DESC; +-------+-----------+-------+ | arena | startwert | offen | +-------+-----------+-------+ | 6 | 0 | 0 | | 5 | 0 | 0 | | 4 | 0 | 0 | | 3 | 0 | 0 | | 2 | 0 | 0 | +-------+-----------+-------+ 5 rows in set (0.00 sec) Everything looks correct.