List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 30 1999 8:37pm
Subject:HEAP tables & indexes troubles
View as plain text  
>>>>> "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
Thread
HEAP tables & indexes troublesAnton Krasovsky16 Jul
  • HEAP tables & indexes troublesMichael Widenius31 Jul