Description:
Heikki,
1) There is only one record with 'GARCIA MANCILLA,S.L'.
2) Mysql reported 53 scanned rows when I ran your mock-up query on your mock-up
table. This is ok.
3) I'm using mysql.exe client (sometimes I use front-end) and i donīt think it
removes the LIMIT 50
from my query.
4) I'm using mysqld-max-nt 4.0.3 beta.
I have sent to pub/mysql/secret the table clientes (clientes.txt) and the my.ini
file
in the compressed file named clientes.zip.
I tell you my test.
a) I ran the following query:
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;
Time:0.08 secs.
Handler_read_next: 1850
(You can verify it through the file clientes.txt I sent)
b) I changed the table type to MyIsam, and I ran the above query:
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;
Time:0.00 secs.
Handler_read_next: 49
So, I have no problems with your mock-up table because (I think) it has not too
many fields.
Also, in my real table, the query is only slow with Innodb table handler. It's
fast with MyIsam
table handler.
I would like you can guess what the problem is and I thank you for your attention.
thanks in advance,
Rafa.
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
