Rafa, ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, September 23, 2002 10:54 AM Subject: optimizer bug in selecting fields that donīt belong to the index used by mysql/innodb
> Description: > Hello, > > I wrote the following text in my last message (It was an answer to Monty): ... > and I have received no answer, so, Have you received the file clientes.zip? > Have you tested it? > Let me know about it. I am sorry we have not yet had time to process this. We have prepared the upcoming MySQL-4.0.4. > Thanks in advance, > Rafa Thank you, Heikki > How-To-Repeat: > Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And > Cod>'059336') Or Nom>'a2618' Order by Nom ASC, Cod ASC Limit 50; > > Fix: > - > > Synopsis:optimizer bug in selecting fields that donīt belong to the index used by mysql/innodb > > Submitter-Id: <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.3 beta(InnoDB) > > Exectutable: mysqld-max-nt > Environment: Pentium III-MMX, 500 MHZ, 540 MB > System: Windows 2000 > Compiler: - > Architecture: i > > __________________________________________________________________ > The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- 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