7 messages in com.mysql.lists.bugsRe: Warning: using a partial-field ke...| From | Sent On | Attachments |
|---|---|---|
| Kevin Day | 07 Mar 2004 04:36 | |
| Sinisa Milivojevic | 08 Mar 2004 04:42 | |
| Kevin Day | 08 Mar 2004 06:14 | |
| Alexander Keremidarski | 08 Mar 2004 07:23 | |
| Heikki Tuuri | 08 Mar 2004 10:19 | |
| Sinisa Milivojevic | 08 Mar 2004 10:31 | |
| Alexander Keremidarski | 12 Mar 2004 06:04 |
| Subject: | Re: Warning: using a partial-field key prefix in search. |
|---|---|
| From: | Alexander Keremidarski (sal...@mysql.com) |
| Date: | 03/08/2004 07:23:50 AM |
| List: | com.mysql.lists.bugs |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi Kevin,
Kevin Day wrote:
Your test script worked for me too, so let me try giving you something more specific to try. This also fails with MyISAM tables, but doesn't print any warning, there's just 0 rows returned when there should be.
mysql test <test-schema-and-data
mysql> select * from t2 WHERE c=1941 AND s>=0 ORDER BY p DESC; Empty set (0.00 sec)
mysql> select * from t2 WHERE c=1941 AND s>=0; *snipped out correct results* 2655 rows in set (0.07 sec)
I got exactly the same result.
mysql> alter table t2 drop key cs;
You don't even need to do that! Look:
mysql> select * from t2 WHERE c=1941 AND s>=0 ORDER BY p DESC; Empty set (0.00 sec)
mysql> select count(*) from t2 WHERE c=1941 AND s>=0 ORDER BY p DESC; +----------+ | count(*) | +----------+ | 2655 | +----------+ 1 row in set (0.01 sec)
It is clear this a bug. I would try to find smaller test case and will enter it into our Bugs database.
Thank you a lot for pointing this to us and for excelent test case.
-- Kevin
Best regards
- -- Meet the MySQL Team at User Conference 2004! http://www.mysql.com/uc2004/
For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <sal...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFATJAcNJ1Mo9yetSkRAuONAJ4iOxkDi8lFZpAs1gg0PShbKTvsEgCdEKSh a7qAnGRWLcJxkxmza2Tbe/4= =zGbJ -----END PGP SIGNATURE-----