Re: Warning: using a partial-field key prefix in search.

On Mar 8, 2004, at 6:43 AM, Sinisa Milivojevic wrote:

> Hi!
>
> Thank you for writting to us.
>
> I have tested your problem with 4.1.2 and it works just fine.
>

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)

mysql> alter table t2 drop key cs;
Query OK, 128267 rows affected (1.33 sec)
Records: 128267  Duplicates: 0  Warnings: 0

mysql> select * from t2 WHERE c=1941 AND s>=0 ORDER BY p DESC;
*snipped out correct results*
2655 rows in set (0.08 sec)


Test schema and data are available at:

http://www.dragondata.com/~toasty/test-schema-and-data.bz2  (431KB)


I'm curious to see if this works in 4.1.2 or not.

Thanks!

-- Kevin