Hi,
How-to-repeat :
SELECT a FROM (SELECT 1 FROM (SELECT 1) HAVING a=1);
ERROR 2013: Lost connection to MySQL server during query
Stack trace :
0x80a1971 handle_segfault(int) + 481
0x8286668 pthread_sighandler + 176
0x804bc29 Item_field::used_tables() const + 9
0x80512c6 Item_ref::used_tables() const + 22
0x80573b3 Item_func::fix_fields(THD*, st_table_list*, Item**) + 211
0x80c8942 JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 514
0x80ca8e6 mysql_select(THD*, st_table_list*, List<Item>&, Item*, st_order*,
st_order*, Item*, st_order*, unsigned long, select_result*,
st_select_lex_unit*, st_select_lex*) + 438
0x8137e54 mysql_derived(THD*, st_lex*, st_select_lex_unit*, st_table_list*)
+ 1236
0x80afaa7 mysql_execute_command(THD*) + 16647
0x80b0585 mysql_parse(THD*, char*, unsigned) + 149
0x80aab27 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80aa7b6 do_command(THD*) + 118
0x80aa08f handle_one_connection(void*) + 895
0x8283efa pthread_start_thread + 218
0x82b83aa thread_start + 4
Regards,
Jocelyn
2 messages in com.mysql.lists.bugsCrash in MySQL 4.1 with derived table...