>>>>> "Arun" == Arun Bhalla <abhalla@stripped> writes:
Arun> Hi, I'm using MySQL 3.23.2-alpha for sun-solaris2.6-sparc.
Arun> My database consists of two tables, one being 350MB, the other being
Arun> 4GB. I've indexed it pretty well; the indexes generally perform pretty
Arun> well. However, for some reason, a small set of cases don't perform well.
Arun> Observe:
mysql> select sample_id from QW_SAMPLE where site_no = '293348094482800' ;
Arun> ...
Arun> 47 rows in set (29.97 sec)
mysql> select sample_id from QW_SAMPLE where site_no = '293348' ;
Arun> Empty set (30.55 sec)
mysql> select sample_id from QW_SAMPLE where site_no = '293347' \g
Arun> Empty set (0.00 sec)
mysql> select sample_id from QW_SAMPLE where site_no = '29334' ;
Arun> Empty set (0.00 sec)
<cut>
Hi!
The fix in this case is to upgrade to 3.23.3; This fixes a bug in the
range optimizer for MyISAM which made MySQL ignore keys in some context.
Regards,
Monty
