#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=0x55555dd4dd20 "query_block->leaf_table_count == 0 || thd->lex->is_query_tables_locked() || query_block == set_operand_block", file=0x55555dd4e868 "/home/wx/mysql-8.0.34/sql/sql_optimizer.cc", line=343, function=<optimized out>) at assert.c:92
#3  0x00007ffff6b03fd6 in __GI___assert_fail ( assertion=assertion@entry=0x55555dd4dd20 "query_block->leaf_table_count == 0 || thd->lex->is_query_tables_locked() || query_block == set_operand_block", file=file@entry=0x55555dd4e868 "/home/wx/mysql-8.0.34/sql/sql_optimizer.cc", line=line@entry=343, function=function@entry=0x55555dd4dce0 "bool JOIN::optimize(bool)") at assert.c:101
#4  0x0000555559491bb8 in JOIN::optimize (this=0x6190005537b0, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:351
#5  0x00005555595b28b0 in Query_block::optimize (this=this@entry=0x6190005401b0, thd=thd@entry=0x6270002bf900, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_select.cc:2013
#6  0x0000555559714de9 in Query_expression::optimize (this=this@entry=0x61200030a0f0, thd=thd@entry=0x6270002bf900, materialize_destination=materialize_destination@entry=0x0, create_iterators=create_iterators@entry=false, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_union.cc:1006
#7  0x00005555595b296b in Query_block::optimize (this=this@entry=0x61900053f7b0, thd=thd@entry=0x6270002bf900, finalize_access_paths=finalize_access_paths@entry=false) at /home/wx/mysql-8.0.34/sql/sql_select.cc:2021
#8  0x0000555559714de9 in Query_expression::optimize (this=this@entry=0x612000309f70, thd=thd@entry=0x6270002bf900, materialize_destination=materialize_destination@entry=0x0, create_iterators=create_iterators@entry=false, finalize_access_paths=finalize_access_paths@entry=false) at /home/wx/mysql-8.0.34/sql/sql_union.cc:1006
#9  0x0000555559e3243d in Item_subselect::exec (this=this@entry=0x61200030a570, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:674
#10 0x0000555559e1eac1 in Item_exists_subselect::val_bool (this=0x61200030a570) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:1606
#11 0x0000555559e1afec in Item_exists_subselect::val_int (this=<optimized out>) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:1568
#12 0x0000555559dee45f in Item_func_repeat::resolve_type (this=0x6120003088f0, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_strfunc.cc:2530
#13 0x0000555559d51c80 in Item_func::fix_fields (this=this@entry=0x6120003088f0, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:422
#14 0x0000555559decf46 in Item_str_func::fix_fields (this=0x6120003088f0, thd=0x6270002bf900, ref=<optimized out>) at /home/wx/mysql-8.0.34/sql/item_strfunc.cc:164
#15 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x612000308a70, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x612000308b20) at /home/wx/mysql-8.0.34/sql/item_func.cc:429
#16 0x0000555559d51c48 in Item_func::fix_fields (this=0x612000308a70, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418
#17 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x618000067cb0, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x60700036d740) at /home/wx/mysql-8.0.34/sql/item_func.cc:429
#18 0x0000555559d51c48 in Item_func::fix_fields (this=this@entry=0x618000067cb0, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418
#19 0x0000555559c9d1a7 in Item_func_between::fix_fields (this=0x618000067cb0, thd=0x6270002bf900, ref=0x61200030a798) at /home/wx/mysql-8.0.34/sql/item_cmpfunc.cc:2896
#20 0x0000555559d5166d in Item_func::fix_func_arg (this=this@entry=0x61200030a6f0, thd=thd@entry=0x6270002bf900, arg=arg@entry=0x61200030a798) at /home/wx/mysql-8.0.34/sql/item_func.cc:429
#21 0x0000555559d51c48 in Item_func::fix_fields (this=0x61200030a6f0, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_func.cc:418
#22 0x000055555957e884 in Query_block::setup_join_cond (this=0x61900053e3b0, thd=<optimized out>, tables=<optimized out>, in_update=<optimized out>) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1743
#23 0x000055555957eb9c in Query_block::setup_join_cond (this=this@entry=0x61900053e3b0, thd=thd@entry=0x6270002bf900, tables=tables@entry=0x61900053e5c8, in_update=in_update@entry=false) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1731
#24 0x000055555957f478 in Query_block::setup_conds (this=this@entry=0x61900053e3b0, thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1711
#25 0x000055555958ce5f in Query_block::prepare (this=this@entry=0x61900053e3b0, thd=thd@entry=0x6270002bf900, insert_field_list=insert_field_list@entry=0x0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:296
#26 0x000055555970ff37 in Query_expression::prepare (this=<optimized out>, thd=thd@entry=0x6270002bf900, sel_result=<optimized out>, insert_field_list=insert_field_list@entry=0x0, added_options=added_options@entry=0, removed_options=removed_options@entry=0) at /home/wx/mysql-8.0.34/sql/sql_union.cc:753
#27 0x000055555a1bfd34 in Table_ref::resolve_derived (this=this@entry=0x61b0006aeab0, thd=thd@entry=0x6270002bf900, apply_semijoin=apply_semijoin@entry=true) at /home/wx/mysql-8.0.34/sql/sql_derived.cc:433
#28 0x0000555559567996 in Query_block::resolve_placeholder_tables (this=this@entry=0x6190005393b0, thd=thd@entry=0x6270002bf900, apply_semijoin=apply_semijoin@entry=true) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:1297
#29 0x000055555958c8d6 in Query_block::prepare (this=this@entry=0x6190005393b0, thd=thd@entry=0x6270002bf900, insert_field_list=insert_field_list@entry=0x0) at /home/wx/mysql-8.0.34/sql/sql_resolver.cc:246
#30 0x00005555595b0c63 in Sql_cmd_select::prepare_inner (this=0x60b000159110, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:650
#31 0x00005555595cd20b in Sql_cmd_dml::prepare (this=0x60b000159110, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:566
#32 0x00005555595cda8d in Sql_cmd_dml::execute (this=0x60b000159110, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:718
#33 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
#34 0x00005555594c0bfe in dispatch_sql_command (thd=0x6270002bf900, parser_state=parser_state@entry=0x7fffc70b8c00) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:5368
#35 0x00005555594c38e2 in dispatch_command (thd=thd@entry=0x6270002bf900, com_data=com_data@entry=0x7fffc70ba200, command=<optimized out>) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:2054
#36 0x00005555594c7392 in do_command (thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:1439
#37 0x000055555989b7be in handle_connection (arg=arg@entry=0x603000185350) at /home/wx/mysql-8.0.34/sql/conn_handler/connection_handler_per_thread.cc:302
#38 0x000055555cc724e9 in pfs_spawn_thread (arg=0x614000140a60) at /home/wx/mysql-8.0.34/storage/perfschema/pfs.cc:3042
#39 0x00007ffff7568609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#40 0x00007ffff6bef133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95