Bug #28542 asc/desc query problem combined with limit and order by
Submitted: 20 May 2007 17:51 Modified: 21 Jun 2007 9:47
Reporter: marc k Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.13 OS:Any
Assigned to: CPU Architecture:Any
Tags: asc, DESC, limit, order by, query

[20 May 2007 17:51] marc k
Description:
$query1 = "select * from table order by id ASC limit $a,1 ";
$query2 = "select * from table order by id DESC limit $a,1 ";

First query is OK
Second query does not return anything

ID is auto_increment int and is also primary key

How to repeat:
try 
$query1 = "select * from table order by id ASC limit $a,1 ";
$query2 = "select * from table order by id DESC limit $a,1 ";

Suggested fix:
unknown
[21 May 2007 9:47] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer server version, 4.1.22.

In case of the same problem, send dump of the table used and describe the environment (some VB appliaction?) you issued these queries from.
[21 Jun 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".