ORDER BY favours full scan over a faster filesort

[Oscar]

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