MySQL Forums
Forum List  »  Quality Assurance

Re: 5.1.23-rc possible order by desc bug
Posted by: Trim Pershad
Date: February 19, 2008 10:39PM

I could not reproduce on 5.1.22.


1.) Created table trackviews as above
2.) Create table mym

Engine=innoDB for both tables.

3.) Inserted rows in both the tables with above data.

Run the following SQL statements:

4.) mysql> select tv.fromClientID as ClientID, tv.trackDate,p.realname
from trackviews tv left join mym p on (tv.fromClientID=p.clientID)
where tv.clientID=32 order by trackdate ASC limit 5;

+----------+------------+--------------+
| ClientID | trackDate | realname |
+----------+------------+--------------+
| 395891 | 1202525736 | da |
| 395218 | 1202549293 | sop |
| 396069 | 1202669189 | t |
| 394466 | 1202929904 | LaurenAndNic |
| 396326 | 1202945744 | stepha |
+----------+------------+--------------+
5 rows in set (0.01 sec)

5.) mysql> select tv.fromClientID as ClientID, tv.trackDate,p.realname
from trackviews tv left join mym p on (tv.fromClientID=p.clientID)
where tv.clientID=32 order by trackdate DESC limit 5;

+----------+------------+--------------+
| ClientID | trackDate | realname |
+----------+------------+--------------+
| 396326 | 1202945744 | stepha |
| 394466 | 1202929904 | LaurenAndNic |
| 396069 | 1202669189 | t |
| 395218 | 1202549293 | sop |
| 395891 | 1202525736 | da |
+----------+------------+--------------+
5 rows in set (0.00 sec)


Can you upload the script for the 2nd table so that we can try again?

Options: ReplyQuote


Subject
Views
Written By
Posted
4331
February 16, 2008 02:55AM
Re: 5.1.23-rc possible order by desc bug
2316
February 19, 2008 10:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.