Re: 5.1.23-rc possible order by desc bug

[Trim Pershad]

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?