#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=0x55555dd47500 "(join_tab->join())->tables == 0 || ((join_tab->join())->best_ref && !(join_tab->join())->join_tab)", file=0x55555dd4e868 "/home/wx/mysql-8.0.34/sql/sql_optimizer.cc", line=8930, function=<optimized out>) at assert.c:92
#3  0x00007ffff6b03fd6 in __GI___assert_fail ( assertion=assertion@entry=0x55555dd47500 "(join_tab->join())->tables == 0 || ((join_tab->join())->best_ref && !(join_tab->join())->join_tab)", file=file@entry=0x55555dd4e868 "/home/wx/mysql-8.0.34/sql/sql_optimizer.cc", line=line@entry=8930, function=function@entry=0x55555dd474a0 "bool test_if_ref(THD*, Item_field*, Item*, bool*)") at assert.c:101
#4  0x0000555559463a63 in test_if_ref (thd=thd@entry=0x6270002bf900, left_item=<optimized out>, right_item=right_item@entry=0x611000112030, redundant=redundant@entry=0x7fffc7076ff0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:8938
#5  0x0000555559464590 in reduce_cond_for_table (thd=thd@entry=0x6270002bf900, cond=cond@entry=0x61500040b5b0, null_extended=null_extended@entry=0, reduced=reduced@entry=0x7fffc70771f0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:9083
#6  0x0000555559463f41 in reduce_cond_for_table (thd=thd@entry=0x6270002bf900, cond=0x612000330670, null_extended=null_extended@entry=0, reduced=reduced@entry=0x7fffc70773e0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:9011
#7  0x0000555559464157 in reduce_cond_for_table (thd=thd@entry=0x6270002bf900, cond=0x6120003307f0, null_extended=0, reduced=reduced@entry=0x7fffc7077570) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:9037
#8  0x0000555559464b8e in JOIN::finalize_table_conditions (this=this@entry=0x61900054abb0, thd=<optimized out>) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:9143
#9  0x0000555559495d67 in JOIN::optimize (this=0x61900054abb0, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:1015
#10 0x00005555595b28b0 in Query_block::optimize (this=this@entry=0x61900053c0b0, thd=thd@entry=0x6270002bf900, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_select.cc:2013
#11 0x0000555559714de9 in Query_expression::optimize (this=this@entry=0x6120003199f0, 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
#12 0x00005555595b296b in Query_block::optimize (this=this@entry=0x61900053b6b0, thd=thd@entry=0x6270002bf900, finalize_access_paths=finalize_access_paths@entry=false) at /home/wx/mysql-8.0.34/sql/sql_select.cc:2021
#13 0x0000555559714de9 in Query_expression::optimize (this=this@entry=0x612000319870, 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
#14 0x0000555559e3243d in Item_subselect::exec (this=this@entry=0x612000319ff0, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:674
#15 0x0000555559e1c775 in Item_singlerow_subselect::val_int (this=0x612000319ff0) at /home/wx/mysql-8.0.34/sql/item_subselect.cc:1241
#16 0x0000555559c4cb20 in Item::evaluate (this=this@entry=0x612000319ff0, thd=<optimized out>, buffer=buffer@entry=0x7fffc7078df0) at /home/wx/mysql-8.0.34/sql/item.cc:7438
#17 0x0000555559c4ce91 in Item::update_null_value (this=this@entry=0x612000319ff0) at /home/wx/mysql-8.0.34/sql/item.cc:7392
#18 0x0000555559e358d5 in Item_subselect::is_null (this=0x612000319ff0) at /home/wx/mysql-8.0.34/sql/item_subselect.h:195
#19 0x0000555559c8f7d3 in Item_func_isnotnull::val_int (this=<optimized out>) at /home/wx/mysql-8.0.34/sql/item_cmpfunc.cc:6204
#20 0x0000555559c65f4d in Item::save_in_field_inner (this=0x612000319270, field=0x612000317bf0, no_conversions=<optimized out>) at /home/wx/mysql-8.0.34/sql/item.cc:6764
#21 0x0000555559c78ced in Item::save_in_field (this=this@entry=0x612000319270, field=field@entry=0x612000317bf0, no_conversions=no_conversions@entry=true) at /home/wx/mysql-8.0.34/sql/item.cc:6634
#22 0x0000555559c79029 in Item::save_in_field_no_warnings (this=this@entry=0x612000319270, field=field@entry=0x612000317bf0, no_conversions=no_conversions@entry=true) at /home/wx/mysql-8.0.34/sql/item.cc:1681
#23 0x000055555a1031c7 in save_value_and_handle_conversion (tree=tree@entry=0x7fffc7079880, value=value@entry=0x612000319270, comp_op=comp_op@entry=Item_func::EQ_FUNC, field=field@entry=0x612000317bf0, impossible_cond_cause=impossible_cond_cause@entry=0x7fffc70798a0, memroot=memroot@entry=0x7fffc707ac50, query_block=0x619000533eb0, inexact=0x60e000074214) at /home/wx/mysql-8.0.34/sql/range_optimizer/range_analysis.cc:1210
#24 0x000055555a104a8a in get_mm_leaf (thd=thd@entry=0x6270002bf900, param=param@entry=0x7fffc707a4c0, cond_func=cond_func@entry=0x6160003b4cb0, field=0x612000317bf0, key_part=key_part@entry=0x6070003840a0, type=type@entry=Item_func::EQ_FUNC, value=<optimized out>, inexact=<optimized out>) at /home/wx/mysql-8.0.34/sql/range_optimizer/range_analysis.cc:1557
#25 0x000055555a1061da in get_mm_parts (thd=thd@entry=0x6270002bf900, param=param@entry=0x7fffc707a4c0, prev_tables=prev_tables@entry=2305843009213693952, read_tables=read_tables@entry=2305843009213693952, cond_func=cond_func@entry=0x6160003b4cb0, field=<optimized out>, type=<optimized out>, value=<optimized out>) at /home/wx/mysql-8.0.34/sql/range_optimizer/range_analysis.cc:1103
#26 0x000055555a10a836 in get_mm_tree (thd=thd@entry=0x6270002bf900, param=param@entry=0x7fffc707a4c0, prev_tables=prev_tables@entry=2305843009213693952, read_tables=read_tables@entry=2305843009213693952, current_table=<optimized out>, remove_jump_scans=remove_jump_scans@entry=true, cond=<optimized out>) at /home/wx/mysql-8.0.34/sql/range_optimizer/range_analysis.cc:979
#27 0x000055555922b131 in test_quick_select (thd=thd@entry=0x6270002bf900, return_mem_root=<optimized out>, temp_mem_root=temp_mem_root@entry=0x7fffc707ac50, keys_to_use=..., prev_tables=prev_tables@entry=0, read_tables=read_tables@entry=0, limit=<optimized out>, force_quick_range=<optimized out>, interesting_order=<optimized out>, table=<optimized out>, skip_records_in_range=<optimized out>, cond=<optimized out>, needed_reg=<optimized out>, ignore_table_scan=<optimized out>, query_block=<optimized out>, path=<optimized out>) at /home/wx/mysql-8.0.34/sql/range_optimizer/range_optimizer.cc:641
#28 0x000055555947d649 in get_quick_record_count (thd=0x6270002bf900, tab=tab@entry=0x6160003b4fb0, limit=<optimized out>, condition=condition@entry=0x6160003b4cb0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:6177
#29 0x000055555947e18e in JOIN::estimate_rowcount (this=this@entry=0x619000546fb0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:5928
#30 0x0000555559491222 in JOIN::make_join_plan (this=this@entry=0x619000546fb0) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:5337
#31 0x0000555559493ff8 in JOIN::optimize (this=0x619000546fb0, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_optimizer.cc:694
#32 0x00005555595b28b0 in Query_block::optimize (this=this@entry=0x619000533eb0, thd=thd@entry=0x6270002bf900, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_select.cc:2013
#33 0x0000555559714de9 in Query_expression::optimize (this=this@entry=0x6120003184f0, thd=thd@entry=0x6270002bf900, materialize_destination=materialize_destination@entry=0x0, create_iterators=create_iterators@entry=true, finalize_access_paths=finalize_access_paths@entry=true) at /home/wx/mysql-8.0.34/sql/sql_union.cc:1006
#34 0x00005555595b1ee9 in Sql_cmd_dml::execute_inner (this=0x60b000158820, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:1007
#35 0x00005555595ce209 in Sql_cmd_dml::execute (this=0x60b000158820, thd=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_select.cc:793
#36 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
#37 0x00005555594c0bfe in dispatch_sql_command (thd=0x6270002bf900, parser_state=parser_state@entry=0x7fffc707ec00) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:5368
#38 0x00005555594c38e2 in dispatch_command (thd=thd@entry=0x6270002bf900, com_data=com_data@entry=0x7fffc7080200, command=<optimized out>) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:2054
#39 0x00005555594c7392 in do_command (thd=thd@entry=0x6270002bf900) at /home/wx/mysql-8.0.34/sql/sql_parse.cc:1439
#40 0x000055555989b7be in handle_connection (arg=arg@entry=0x603000168310) at /home/wx/mysql-8.0.34/sql/conn_handler/connection_handler_per_thread.cc:302
#41 0x000055555cc724e9 in pfs_spawn_thread (arg=0x614000140a60) at /home/wx/mysql-8.0.34/storage/perfschema/pfs.cc:3042
#42 0x00007ffff7568609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#43 0x00007ffff6bef133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95