Crash in MySQL 4.1 with derived table and Having

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*, 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


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