Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
Stack trace from 47a7c314ca44dbea2a91322c51a568680812e644 |
#3 <signal handler called>
|
#4 0x000055559513f7a2 in Bitmap<64u>::merge (this=0x1a8, map2=...) at /src/10.2/sql/sql_bitmap.h:196
|
#5 0x00005555951e112b in add_key_field (join=0x7fe0cc8677a0, key_fields=0x7fe0d83cfda8, and_level=0, cond=0x7fe0cc86b070, field=0x7fe0cc98e3a8, eq_func=true, value=0x7fe0cc86b100, num_values=1, usable_tables=18446744073709551615, sargables=0x7fe0d83cfe98) at /src/10.2/sql/sql_select.cc:4652
|
#6 0x00005555951e146a in add_key_equal_fields (join=0x7fe0cc8677a0, key_fields=0x7fe0d83cfda8, and_level=0, cond=0x7fe0cc86b070, field_item=0x7fe0cc9c9c98, eq_func=true, val=0x7fe0cc86b100, num_values=1, usable_tables=18446744073709551615, sargables=0x7fe0d83cfe98) at /src/10.2/sql/sql_select.cc:4762
|
#7 0x00005555951e2164 in Item_bool_func2::add_key_fields_optimize_op (this=0x7fe0cc86b070, join=0x7fe0cc8677a0, key_fields=0x7fe0d83cfda8, and_level=0x7fe0d83cfd98, usable_tables=18446744073709551615, sargables=0x7fe0d83cfe98, equal_func=true) at /src/10.2/sql/sql_select.cc:5027
|
#8 0x0000555595428449 in Item_func_eq::add_key_fields (this=0x7fe0cc86b070, join=0x7fe0cc8677a0, key_fields=0x7fe0d83cfda8, and_level=0x7fe0d83cfd98, usable_tables=18446744073709551615, sargables=0x7fe0d83cfe98) at /src/10.2/sql/item_cmpfunc.h:648
|
#9 0x00005555951e3745 in update_ref_and_keys (thd=0x7fe0cc82def0, keyuse=0x7fe0d83cfea0, join_tab=0x7fe0cc86a6a0, tables=1, cond=0x7fe0cc86b070, normal_tables=18446744073709551615, select_lex=0x7fe0cc9c85b0, sargables=0x7fe0d83cfe98) at /src/10.2/sql/sql_select.cc:5497
|
#10 0x000055559521342b in JOIN::reoptimize (this=0x7fe0cc8677a0, added_where=0x7fe0cc86b070, join_tables=1, save_to=0x0) at /src/10.2/sql/sql_select.cc:25179
|
#11 0x0000555595328112 in JOIN::choose_subquery_plan (this=0x7fe0cc8677a0, join_tables=1) at /src/10.2/sql/opt_subselect.cc:5689
|
#12 0x00005555951e05dd in make_join_statistics (join=0x7fe0cc8677a0, tables_list=..., keyuse_array=0x7fe0cc867a80) at /src/10.2/sql/sql_select.cc:4313
|
#13 0x00005555951d662d in JOIN::optimize_inner (this=0x7fe0cc8677a0) at /src/10.2/sql/sql_select.cc:1427
|
#14 0x00005555951d5414 in JOIN::optimize (this=0x7fe0cc8677a0) at /src/10.2/sql/sql_select.cc:1070
|
#15 0x000055559518a711 in st_select_lex::optimize_unflattened_subqueries (this=0x7fe0cc9c7000, const_only=false) at /src/10.2/sql/sql_lex.cc:3807
|
#16 0x0000555595548651 in mysql_delete (thd=0x7fe0cc82def0, table_list=0x7fe0cc9c7eb0, conds=0x7fe0cc90d4b0, order_list=0x7fe0cc9c7238, limit=18446744073709551615, options=0, result=0x0) at /src/10.2/sql/sql_delete.cc:311
|
#17 0x000055559519bca5 in mysql_execute_command (thd=0x7fe0cc82def0) at /src/10.2/sql/sql_parse.cc:4470
|
#18 0x00005555951c0d85 in Prepared_statement::execute (this=0x7fe0cc949070, expanded_query=0x7fe0d83d1d80, open_cursor=false) at /src/10.2/sql/sql_prepare.cc:4277
|
#19 0x00005555951bfc20 in Prepared_statement::execute_loop (this=0x7fe0cc949070, expanded_query=0x7fe0d83d1d80, open_cursor=false, packet=0x0, packet_end=0x0) at /src/10.2/sql/sql_prepare.cc:3908
|
#20 0x00005555951bdca9 in mysql_sql_stmt_execute (thd=0x7fe0cc82def0) at /src/10.2/sql/sql_prepare.cc:3036
|
#21 0x00005555951987a6 in mysql_execute_command (thd=0x7fe0cc82def0) at /src/10.2/sql/sql_parse.cc:3349
|
#22 0x00005555951a6106 in mysql_parse (thd=0x7fe0cc82def0, rawbuf=0x7fe0cc867448 "execute stmt", length=12, parser_state=0x7fe0d83d29e0, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7703
|
#23 0x0000555595194647 in dispatch_command (command=COM_QUERY, thd=0x7fe0cc82def0, packet=0x7fe0cc861171 "execute stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1790
|
#24 0x00005555951930bc in do_command (thd=0x7fe0cc82def0) at /src/10.2/sql/sql_parse.cc:1353
|
#25 0x00005555952c9392 in do_handle_one_connection (connect=0x7fe0d5c84310) at /src/10.2/sql/sql_connect.cc:1358
|
#26 0x00005555952c9124 in handle_one_connection (arg=0x7fe0d5c84310) at /src/10.2/sql/sql_connect.cc:1264
|
#27 0x00005555959de420 in pfs_spawn_thread (arg=0x7fe0d11c6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
|
#28 0x00007fe0d804d0a4 in start_thread () from /lib64/libpthread.so.0
|
#29 0x00007fe0d61bb04d in clone () from /lib64/libc.so.6
|
Test case |
create table t1 (i int); |
prepare stmt from "delete from t1 where i in ( select i from ( with x as ( select i from t1 ) select * from x ) sq)"; |
execute stmt; |
insert into t1 values (1),(2); |
execute stmt; |