>>>>> "Anton" == Anton Krasovsky <anton@stripped> writes:
>> Description:
Anton> unable to perform selects from heap tables
Anton> using < or > when key field is indexed
Anton> mysql dumps core when removing index from
Anton> heap table
>> How-To-Repeat:
mysql> select id from active where id > 10;
Anton> +--------+
Anton> | id |
Anton> +--------+
Anton> | 869751 |
Anton> | 736494 |
Anton> | 226312 |
Anton> | 802616 |
Anton> | 67585 |
Anton> | 451952 |
Anton> | 668080 |
Anton> | 806056 |
Anton> | 113455 |
Anton> | 773451 |
Anton> | 85834 |
Anton> +--------+
Anton> 11 rows in set (0.01 sec)
mysql> alter table active add unique uniq_id(id);
Anton> Query OK, 11 rows affected (0.09 sec)
Anton> Records: 11 Duplicates: 0 Warnings: 0
mysql> select id from active where id > 10;
Anton> Empty set (0.01 sec)
mysql> alter table active drop index uniq_id;
Anton> ERROR 2013: Segmentation fault - core dumped
Anton> Lost connection to MySQL server during query
Thanks for the clear bug report. These problems are now fixed for
MySQL 3.23.2!
Regards,
Monty
