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

2003-03-19 Thread Peter Zaitsev
On Tue, 2003-03-18 at 21:38, [EMAIL PROTECTED] 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 yo

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

2003-02-26 Thread Alexander Keremidarski
Hello, [EMAIL PROTECTED] wrote: Description: Hello, I am working with mysql/InnoDb 4.0.11 under Windows 2000. I have the following table: Time: 0.20 secs. Explain: table type possible_keys keykey_len ref rows Extra GIROS range PRI