Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
None
Description
When executing the following query
SELECT table2 .`col_int`
FROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = table4 .`col_int_key` ON table2 .`col_varchar_10_latin1` = table6 .`col_varchar_10_utf8_key`
;
the server crashed as follows:
#5 0x00b774f4 in __bzero_sse2 () from /lib/libc.so.6
#6 0x082dae51 in JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table (this=0xb6db6528) at sql_join_cache.cc:2916
#7 0x082da95d in JOIN_CACHE_BKA_UNIQUE::reset (this=0xb6db6528, for_writing=true) at sql_join_cache.cc:2659
#8 0x082d92d0 in JOIN_CACHE::join_records (this=0xb6db6528, skip_last=false) at sql_join_cache.cc:1709
#9 0x082d9102 in JOIN_CACHE::join_records (this=0xb6d96450, skip_last=false) at sql_join_cache.cc:1650
#10 0x0831ef60 in sub_select_cache (join=0xb6d8df88, join_tab=0xb6d94a20, end_of_records=true) at sql_select.cc:12822
#11 0x0831f179 in sub_select (join=0xb6d8df88, join_tab=0xb6d94860, end_of_records=true) at sql_select.cc:12984
#12 0x0831e733 in do_select (join=0xb6d8df88, fields=0x9fef714, table=0x0, procedure=0x0) at sql_select.cc:12580
#13 0x08304ac1 in JOIN::exec (this=0xb6d8df88) at sql_select.cc:2300
#14 0x083051f7 in mysql_select (thd=0x9fedd00, rref_pointer_array=0x9fef798, tables=0xb6d80808, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6d8df58, unit=0x9fef3dc, select_lex=0x9fef67c) at sql_select.cc:2501
#15 0x082fd95b in handle_select (thd=0x9fedd00, lex=0x9fef380, result=0xb6d8df58, setup_tables_done_option=0) at sql_select.cc:276
#16 0x0829bf3c in execute_sqlcom_select (thd=0x9fedd00, all_tables=0xb6d80808) at sql_parse.cc:5081
#17 0x08292914 in mysql_execute_command (thd=0x9fedd00) at sql_parse.cc:2265
#18 0x0829e0fd in mysql_parse (thd=0x9fedd00,
inBuf=0xb6d4ecc8 "SELECT table2 .`col_int`\nFROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = tab"..., length=291, found_semicolon=0xa6eb7230) at sql_parse.cc:6027
#19 0x082903ca in dispatch_command (command=COM_QUERY, thd=0x9fedd00, packet=0x9fefd21 "", packet_length=292) at sql_parse.cc:1184
#20 0x0828f8b8 in do_command (thd=0x9fedd00) at sql_parse.cc:890
#21 0x0828c8f0 in handle_one_connection (arg=0x9fedd00) at sql_connect.cc:1153
#22 0x00bea919 in start_thread () from /lib/libpthread.so.0
#23 0x00b2ccbe in clone () from /lib/libc.so.6