#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x00007ffff6af2859 in __GI_abort () at abort.c:79 #2 0x00007ffff6af2729 in __assert_fail_base (fmt=0x7ffff6c88588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55555dfdf920 "aggr_query_block != removed_query_block", file=0x55555dfdbc60 "/home/wx/mysql-8.0.34/sql/item_sum.cc", line=784, function=) at assert.c:92 #3 0x00007ffff6b03fd6 in __GI___assert_fail (assertion=assertion@entry=0x55555dfdf920 "aggr_query_block != removed_query_block", file=file@entry=0x55555dfdbc60 "/home/wx/mysql-8.0.34/sql/item_sum.cc", line=line@entry=784, function=function@entry=0x55555dfdf8a0 "virtual void Item_sum::fix_after_pullout(Query_block*, Query_block*)") at assert.c:101 #4 0x0000555559e4d544 in Item_sum::fix_after_pullout (this=0x614000160670, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_sum.cc:800 #5 0x0000555559c7a6ea in Item_cache::fix_after_pullout (this=0x61100011e970, parent_query_block=, removed_query_block=) at /home/wx/mysql-8.0.34/sql/item.h:6681 #6 0x0000555559c5255d in Item_ref::fix_after_pullout (this=0x612000332d70, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item.cc:8641 #7 0x0000555559d439fd in Item_func::fix_after_pullout (this=0x615000411eb0, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_func.cc:469 #8 0x0000555559cb7602 in Item_cond::fix_after_pullout (this=0x612000333370, parent_query_block=, removed_query_block=) at /home/wx/mysql-8.0.34/sql/item_cmpfunc.cc:5698 #9 0x0000555559d439fd in Item_func::fix_after_pullout (this=this@entry=0x6120003334f0, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_func.cc:469 #10 0x0000555559ccde9b in Item_func_trig_cond::fix_after_pullout (this=0x6120003334f0, parent_query_block=, removed_query_block=) at /home/wx/mysql-8.0.34/sql/item_cmpfunc.h:895 #11 0x0000555559564e20 in Query_block::fix_after_pullout (this=this@entry=0x6190005438b0, parent_query_block=parent_query_block@entry=0x61900053a2b0, removed_query_block=removed_query_block@entry=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:2382 #12 0x00005555595654ee in Query_expression::fix_after_pullout (this=, parent_query_block=parent_query_block@entry=0x61900053a2b0, removed_query_block=removed_query_block@entry=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:2373 #13 0x0000555559e26aed in Item_subselect::fix_after_pullout (this=this@entry=0x614000160870, parent_query_block=parent_query_block@entry=0x61900053a2b0, removed_query_block=removed_query_block@entry=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:708 #14 0x0000555559e26bd9 in Item_in_subselect::fix_after_pullout (this=0x614000160870, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:2532 #15 0x0000555559c8b1f4 in Item_in_optimizer::fix_after_pullout (this=0x612000332bf0, parent_query_block=0x61900053a2b0, removed_query_block=0x619000542eb0) at /home/wx/mysql-8.0.34/sql/item_cmpfunc.cc:2223 #16 0x0000555559e23e80 in Item_singlerow_subselect::select_transformer (this=0x612000331270, thd=, select=) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:1155 #17 0x000055555956fc7a in Query_block::resolve_subquery (this=this@entry=0x619000542eb0, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1593 #18 0x000055555958dd45 in Query_block::prepare (this=this@entry=0x619000542eb0, thd=thd@entry=0x6270002bf900, insert_field_list=insert_field_list@entry=0x0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:449 #19 0x000055555970ff37 in Query_expression::prepare (this=this@entry=0x612000330f70, thd=thd@entry=0x6270002bf900, sel_result=, insert_field_list=insert_field_list@entry=0x0, added_options=added_options@entry=268435456, removed_options=removed_options@entry=0) at /home/wx/mysql-8.0.34/sql/sql_union.cc:753 #20 0x0000555559e1f1d8 in SubqueryWithResult::prepare (this=0x608001382b50, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:2971 #21 0x0000555559e31605 in Item_subselect::fix_fields (this=0x612000331270, thd=0x6270002bf900, ref=) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:547 #22 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x6120002ef9f0, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x6120002efaa0) at /home/wx/mysql-8.0.34/sql/item_func.cc:429 #23 0x0000555559d51c48 in Item_func::fix_fields (this=0x6120002ef9f0, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418 #24 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x6120002efb70, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x6120002efc18) at /home/wx/mysql-8.0.34/sql/item_func.cc:429 #25 0x0000555559d51c48 in Item_func::fix_fields (this=0x6120002efb70, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418 #26 0x0000555559e31c77 in Item_in_subselect::fix_fields (this=0x614000160c70, thd=0x6270002bf900, ref=0x612000331918) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:2519 #27 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x612000331870, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x612000331918) at /home/wx/mysql-8.0.34/sql/item_func.cc:429 #28 0x0000555559d51c48 in Item_func::fix_fields (this=0x612000331870, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418 #29 0x000055555957f140 in Query_block::setup_conds (this=this@entry=0x61900053a2b0, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1686 #30 0x000055555958ce5f in Query_block::prepare (this=this@entry=0x61900053a2b0, thd=thd@entry=0x6270002bf900, insert_field_list=insert_field_list@entry=0x0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:296 #31 0x00005555595b0c63 in Sql_cmd_select::prepare_inner (this=0x60b000159e20, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:650 #32 0x00005555595cd20b in Sql_cmd_dml::prepare (this=0x60b000159e20, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:566 #33 0x00005555595cda8d in Sql_cmd_dml::execute (this=0x60b000159e20, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:718 #34 0x00005555594bd568 in mysql_execute_command (thd=thd@entry=0x6270002bf900, first_level=first_level@entry=true) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:4719 #35 0x00005555594c0bfe in dispatch_sql_command (thd=0x6270002bf900, parser_state=parser_state@entry=0x7fffc7078c00) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:5368 #36 0x00005555594c38e2 in dispatch_command (thd=thd@entry=0x6270002bf900, com_data=com_data@entry=0x7fffc707a200, command=) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:2054 #37 0x00005555594c7392 in do_command (thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:1439 #38 0x000055555989b7be in handle_connection (arg=arg@entry=0x603000169b10) at /home/wx/mysql-8.0.34/sql/conn_handler/connection_handler_per_thread.cc:302 #39 0x000055555cc724e9 in pfs_spawn_thread (arg=0x614000140a60) at /home/wx/mysql-8.0.34/storage/perfschema/pfs.cc:3042 #40 0x00007ffff7568609 in start_thread (arg=) at pthread_create.c:477 #41 0x00007ffff6bef133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95