optimizer bug in the index used by mysql/Innodb in the search

Description:

Hello Peter,

Have you explained to Heikki this problem?
Have you fixed it?

Please, tell me about it.

Regards,

Rafa



How-To-Repeat:
Select ... from giros ...

Fix:
-

Synopsis:optimizer bug in the index used by mysql/Innodb in the search

Submitter-Id:
Originator: Rafa
Organization: Pecomark
MySQL support: none
Severity: non-critical
Priority: medium
Category: mysqld-max-nt
Class: sw-bug
Release: mysqld 4.0.11 Gamma(InnoDB)

Exectutable: mysqld-max-nt
Environment: Pentium III-MMX, 500 MHZ, 540 MB
System: Windows 2000
Compiler: -
Architecture: i


____________________________________________________________ ______
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promos=380455

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: optimizer bug in the index used by mysql/Innodb in the search

On Tue, 2003-03-18 at 21:38, rafarife@netscape.net wrote:
> Description:
>
> Hello Peter,
>
> Have you explained to Heikki this problem?
> Have you fixed it?
>
> Please, tell me about it.
>

Dear Rafarife,

This problem is qualified as wrong optimizer plan selection.
Happily you can select proper plan by using FORCE INDEX() clause.

We will improve optimizer to handle this case, but I can't promise you
how soon this would happen - it is very tricky task as you need to make
sure your changes do not worsen behavior in other cases.

Also I would recommend you to posting your message to most appropriate
mailing list instead of both. Many users are subscribed to both mailing
list and they will get your message twice.


--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: optimizer bug in the index used by mysql/Innodb in the search

On Tue, 2003-03-18 at 21:38, rafarife@netscape.net wrote:
> Description:
>
> Hello Peter,
>
> Have you explained to Heikki this problem?
> Have you fixed it?
>
> Please, tell me about it.
>

Dear Rafarife,

This problem is qualified as wrong optimizer plan selection.
Happily you can select proper plan by using FORCE INDEX() clause.

We will improve optimizer to handle this case, but I can't promise you
how soon this would happen - it is very tricky task as you need to make
sure your changes do not worsen behavior in other cases.

Also I would recommend you to posting your message to most appropriate
mailing list instead of both. Many users are subscribed to both mailing
list and they will get your message twice.


--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php