ORDER BY favours full scan over a faster filesort

hi all,

it said the bug has been fixed in 5.1.25.
See http://bugs.mysql.com/bug.php?id=35844



# Query_time: 1.657438 Lock_time: 0.000085 Rows_sent: 40 Rows_examined: 885756
SET timestamp=1261447735;
select item0_.id as id163_, item0_.add_time as add2_163_ from item
item0_ where item0_.role_id=2556 order by item0_.id desc;


mysql version: 5.1.34



have you guys met this problem?

thanks,

-Oscar

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org