Crash in DELETE with MySQL-4.1 (bug in error handling ?)

Hi,

How-to-repeat :

CREATE TABLE `t` (
`i` int(10) NOT NULL default '0',
`i2` int(10) NOT NULL default '0',
PRIMARY KEY (`i`)
) TYPE=MyISAM CHARSET=latin1;

DELETE FROM t USING t WHERE post='1';
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80ae909 handle_segfault + 681
0x8295558 pthread_sighandler + 176
0x804a279 st_select_lex::outer_select() + 9
0x804cc40 Item_field::fix_fields(THD*, st_table_list*, Item**) + 416
0x8059332 Item_func::fix_fields(THD*, st_table_list*, Item**) + 146
0x80d4020 setup_conds(THD*, st_table_list*, Item**) + 1696
0x80d7ea1 JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 305
0x80da0bd mysql_select(THD*, st_table_list*, List&, Item*, st_order*,
st_order*, Item*, st_order*, unsigned long, select_result*,
st_select_lex_unit*, st_select_lex*) + 445
0x80bed3c mysql_execute_command(THD*) + 15164
0x80bfcc8 mysql_parse(THD*, char*, unsigned) + 248
0x80ba1bd dispatch_command(enum_server_command, THD*, char*, unsigned) + 925
0x80b9e06 do_command(THD*) + 118
0x80b96d7 handle_one_connection + 855
0x8292f7a pthread_start_thread + 218
0x82c6e5a thread_start + 4

As well, this error description is rather strange :

DELETE FROM t,dontcare USING t WHERE post='1';
ERROR 1066: Not unique table/alias: 'dontcare'

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-thread13290@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in DELETE with MySQL-4.1 (bug in error handling ?)

Hi!

On Sun, Dec 15, 2002 at 04:28:09PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> CREATE TABLE `t` (
> `i` int(10) NOT NULL default '0',
> `i2` int(10) NOT NULL default '0',
> PRIMARY KEY (`i`)
> ) TYPE=MyISAM CHARSET=latin1;
>
> DELETE FROM t USING t WHERE post='1';
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bugreport! I fixed this bug (patch is committed & pushed ("moved
links initialization")).

[skip]

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
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-thread13295@lists.mysql.com
To unsubscribe, e-mail