Re: Another crash in UPDATE with subqueries with MySQL-4.1

On Fri, 2002-11-29 at 02:38, Jocelyn Fournier wrote:

I have repeated this too.
Under investigation :)
--
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ 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-thread13142@lists.mysql.com
To unsubscribe, e-mail

Another crash in UPDATE with subqueries with MySQL-4.1

Hi,

How-to-repeat :

CREATE TABLE `t` (
`id` int(11) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM CHARSET=latin1

INSERT INTO t VALUES (1);

mysql> UPDATE t SET id=(SELECT id FROM (SELECT 1) WHERE id=2);
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a1dd1 handle_segfault + 481
0x828c758 pthread_sighandler + 176
0x80d9ed4 add_key_field(key_field_t**, unsigned, Field*, bool, Item*,
unsigned long) + 244
0x80d8fb4 add_key_fields(st_join_table*, key_field_t**, unsigned*, Item*,
unsigned long) + 404
0x80d4b59 update_ref_and_keys(THD*, st_dynamic_array*, st_join_table*,
unsigned, Item*, unsigned long, st_select_lex*) + 121
0x80cf6b2 make_join_statistics(JOIN*, st_table_list*, Item*,
st_dynamic_array*) + 962
0x80cad8e JOIN::optimize() + 350
0x808643e subselect_single_select_engine::exec() + 270
0x80853d7 Item_singleval_subselect::val_int() + 23
0x804ceb4 Item::save_in_field(Field*) + 68
0x80c675a fill_record(List&, List&) + 90
0x80e115e mysql_update(THD*, st_table_list*, List&, List&,
Item*, st_order*, unsigned long, enum_duplicates) + 2398
0x80af3d3 mysql_execute_command(THD*) + 4435
0x80b3248 mysql_parse(THD*, char*, unsigned) + 152
0x80ad3d4 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852
0x80ad066 do_command(THD*) + 118
0x80ac94e handle_one_connection + 910
0x828a17a pthread_start_thread + 218
0x82be49a thread_start + 4

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