Crash with RTREE and MySQL-4.1

Hi,

How-to-repeat :

CREATE TABLE `rt` (
`a` int(11) NOT NULL default '0',
`b` int(11) NOT NULL default '0',
UNIQUE KEY `a` USING RTREE (`a`,`b`)
) TYPE=MyISAM CHARSET=latin1

INSERT INTO rt VALUES (1,1),(1,1);

DELETE FROM rt WHERE a<1;
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a9f91 handle_segfault + 481
0x829ba58 pthread_sighandler + 176
0x82466b9 _mi_pack_key + 409
0x825560e mi_records_in_range + 398
0x810bb7c check_quick_keys(st_qsel_param*, unsigned, SEL_ARG*, char*,
unsigned, char*, unsigned) + 668
0x810af33 check_quick_select(st_qsel_param*, unsigned, SEL_ARG*) + 131
0x8109201 SQL_SELECT::test_quick_select(unsigned long, unsigned long,
unsigned long, bool) + 1233
0x80ed485 mysql_delete(THD*, st_table_list*, Item*, st_order*, unsigned
long, unsigned long) + 453
0x80b82b6 mysql_execute_command(THD*) + 3878
0x80bc3c8 mysql_parse(THD*, char*, unsigned) + 248
0x80b6283 dispatch_command(enum_server_command, THD*, char*, unsigned) + 867
0x80b5ed2 do_command(THD*) + 130
0x80b578e handle_one_connection + 910
0x829947a pthread_start_thread + 218
0x82cd79a thread_start + 4

BTW, why is this possible to insert several times the same couple of result
even with a UNIQUE (or PRIMARY) KEY ?

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13427@lists.mysql.com
To unsubscribe, e-mail