Hi.
On Fri, Jul 13, 2001 at 02:10:54PM +0200, [EMAIL PROTECTED] wrote:
> On Don, 12 Jul 2001, Gerald Clark wrote:
>
> >It may be the DESC that prohibits the use of the index.
> >Try an normal ascending order.
>
> Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not.
> I think maybe that this is a real _bug_ in mysql. :-(
>
> Does somebody know if this will be fixed sometimes?
If I understand it correctly, this is a known and fixed bug:
>From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html:
----------------------------------------------------------------------
F.2.3 Changes in release 3.23.38
[...]
* Changed optimizer so that queries like SELECT * FROM
table_name,table_name2 ... ORDER BY key_part1 LIMIT # will use
index on key_part1 instead of filesort.
[...]
----------------------------------------------------------------------
Since 3.23.30, as you said you use, MySQL has experienced a lot of
improvement, so you may want to upgrade to the current release 3.23.39.
Btw, it is always a good idea to upgrade to a recent version before
reporting bugs. If that is not possible, please check the archives or
the changes history whether the bug has been fixed meanwhile.
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
