Assertion `item->name.str && item->name.str[0]' failed in TABLE_LIST::create_field_translation on SELECT

CREATE TABLE t (pk INT PRIMARY KEY);

SELECT SHA(pk) IN (SELECT * FROM (SELECT '' FROM t) AS a) FROM t;

mysqld: /test/10.6_dbg/sql/table.cc:5614: bool TABLE_LIST::create_field_translation(THD*): Assertion `item->name.str && item->name.str[0]' failed.

Core was generated by `/test/MD010121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[Current thread is 1 (Thread 0x14d19c551700 (LWP 2154555))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

#1  0x0000556fd7aa70d7 in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424

#2  0x0000556fd723bab1 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x000014d1b23c6859 in __GI_abort () at abort.c:79

#6  0x000014d1b23c6729 in __assert_fail_base (fmt=0x14d1b255c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556fd7c2fea8 "item->name.str && item->name.str[0]", file=0x556fd7c2ccb5 "/test/10.6_dbg/sql/table.cc", line=5614, function=<optimized out>) at assert.c:92

#7  0x000014d1b23d7f36 in __GI___assert_fail (assertion=assertion@entry=0x556fd7c2fea8 "item->name.str && item->name.str[0]", file=file@entry=0x556fd7c2ccb5 "/test/10.6_dbg/sql/table.cc", line=line@entry=5614, function=function@entry=0x556fd7c2fed0 "bool TABLE_LIST::create_field_translation(THD*)") at assert.c:101

#8  0x0000556fd708d859 in TABLE_LIST::create_field_translation (this=this@entry=0x14d1600148a8, thd=thd@entry=0x14d160000db8) at /test/10.6_dbg/sql/table.cc:5614

#9  0x0000556fd7090c64 in TABLE_LIST::init_derived (this=this@entry=0x14d1600148a8, thd=thd@entry=0x14d160000db8, init_view=init_view@entry=false) at /test/10.6_dbg/sql/table.cc:9272

#10 0x0000556fd6f1acae in mysql_derived_prepare (thd=0x14d160000db8, lex=0x14d160004eb8, derived=0x14d1600148a8) at /test/10.6_dbg/sql/sql_derived.cc:830

#11 0x0000556fd6f18f0c in mysql_handle_single_derived (lex=lex@entry=0x14d160004eb8, derived=derived@entry=0x14d1600148a8, phases=phases@entry=2) at /test/10.6_dbg/sql/sql_derived.cc:206

#12 0x0000556fd708d39b in TABLE_LIST::handle_derived (this=this@entry=0x14d1600148a8, lex=lex@entry=0x14d160004eb8, phases=phases@entry=2) at /test/10.6_dbg/sql/table.cc:9120

#13 0x0000556fd6f3d5c5 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x14d160004eb8) at /test/10.6_dbg/sql/table.h:2704

#14 st_select_lex::handle_derived (this=<optimized out>, lex=0x14d160004eb8, phases=phases@entry=2) at /test/10.6_dbg/sql/sql_lex.cc:4911

#15 0x0000556fd6fddf55 in JOIN::prepare (this=0x14d160017200, tables_init=<optimized out>, conds_init=<optimized out>, og_num=0, order_init=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14d160012e70, unit_arg=0x14d160014f98) at /test/10.6_dbg/sql/sql_select.cc:1158

#16 0x0000556fd734f8e8 in subselect_single_select_engine::prepare (this=0x14d1600159e0, thd=0x14d160000db8) at /test/10.6_dbg/sql/sql_lex.h:1350

#17 0x0000556fd734ea35 in Item_subselect::fix_fields (this=this@entry=0x14d160015798, thd_param=thd_param@entry=0x14d160000db8, ref=ref@entry=0x14d160015a28) at /test/10.6_dbg/sql/item_subselect.cc:285

#18 0x0000556fd734f0ec in Item_in_subselect::fix_fields (this=0x14d160015798, thd_arg=0x14d160000db8, ref=0x14d160015a28) at /test/10.6_dbg/sql/item_subselect.cc:3438

#19 0x0000556fd6ee7afd in Item::fix_fields_if_needed (ref=0x14d160015a28, thd=0x14d160000db8, this=0x14d160015798) at /test/10.6_dbg/sql/sql_list.h:199

#20 Item::fix_fields_if_needed_for_scalar (ref=0x14d160015a28, thd=0x14d160000db8, this=0x14d160015798) at /test/10.6_dbg/sql/item.h:992

#21 setup_fields (thd=0x14d160000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14d160016e50, pre_fix=0x14d160012910, allow_sum_func=true) at /test/10.6_dbg/sql/sql_base.cc:7602

#22 0x0000556fd6fde60d in JOIN::prepare (this=this@entry=0x14d160016b28, tables_init=tables_init@entry=0x14d160015aa0, conds_init=conds_init@entry=0x0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14d1600127a8, unit_arg=0x14d160004f80) at /test/10.6_dbg/sql/sql_select.cc:1259

#23 0x0000556fd6ff7997 in mysql_select (thd=thd@entry=0x14d160000db8, tables=0x14d160015aa0, fields=@0x14d1600128f8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14d160015a20, last = 0x14d160015a20, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14d160016b00, unit=0x14d160004f80, select_lex=0x14d1600127a8) at /test/10.6_dbg/sql/sql_select.cc:4644

#24 0x0000556fd6ff7cd0 in handle_select (thd=thd@entry=0x14d160000db8, lex=lex@entry=0x14d160004eb8, result=result@entry=0x14d160016b00, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.6_dbg/sql/sql_select.cc:417

#25 0x0000556fd6f6a19d in execute_sqlcom_select (thd=thd@entry=0x14d160000db8, all_tables=0x14d160015aa0) at /test/10.6_dbg/sql/sql_parse.cc:6116

#26 0x0000556fd6f76c7c in mysql_execute_command (thd=thd@entry=0x14d160000db8) at /test/10.6_dbg/sql/sql_parse.cc:3820

#27 0x0000556fd6f63072 in mysql_parse (thd=thd@entry=0x14d160000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14d19c5503d0) at /test/10.6_dbg/sql/sql_parse.cc:7881

#28 0x0000556fd6f711ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14d160000db8, packet=packet@entry=0x14d160008d39 "SELECT SHA(pk) IN (SELECT * FROM (SELECT '' FROM t) AS a) FROM t", packet_length=packet_length@entry=64) at /test/10.6_dbg/sql/sql_class.h:1293

#29 0x0000556fd6f7452d in do_command (thd=0x14d160000db8) at /test/10.6_dbg/sql/sql_parse.cc:1348

#30 0x0000556fd70d07fc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x556fda654998, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410

#31 0x0000556fd70d0f03 in handle_one_connection (arg=arg@entry=0x556fda654998) at /test/10.6_dbg/sql/sql_connect.cc:1312

#32 0x0000556fd758688f in pfs_spawn_thread (arg=0x556fda5a0898) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201

#33 0x000014d1b28d4609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#34 0x000014d1b24c3293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

mysqld: /test/10.2_dbg/sql/table.cc:4832: bool TABLE_LIST::create_field_translation(THD*): Assertion `item->name && item->name[0]' failed.

Core was generated by `/test/MD010121-mariadb-10.2.37-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[Current thread is 1 (Thread 0x14d05b82d700 (LWP 2177880))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

#1  0x00005582efc1ac2a in my_write_core (sig=sig@entry=6) at /test/10.2_dbg/mysys/stacktrace.c:382

#2  0x00005582ef50d82b in handle_fatal_signal (sig=6) at /test/10.2_dbg/sql/signal_handler.cc:343

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x000014d0a28cf859 in __GI_abort () at abort.c:79

#6  0x000014d0a28cf729 in __assert_fail_base (fmt=0x14d0a2a65588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5582efcd352b "item->name && item->name[0]", file=0x5582efcd2db4 "/test/10.2_dbg/sql/table.cc", line=4832, function=<optimized out>) at assert.c:92

#7  0x000014d0a28e0f36 in __GI___assert_fail (assertion=assertion@entry=0x5582efcd352b "item->name && item->name[0]", file=file@entry=0x5582efcd2db4 "/test/10.2_dbg/sql/table.cc", line=line@entry=4832, function=function@entry=0x5582efcd2c48 "bool TABLE_LIST::create_field_translation(THD*)") at assert.c:101

#8  0x00005582ef3e8c27 in TABLE_LIST::create_field_translation (this=this@entry=0x14d038013368, thd=thd@entry=0x14d038000d90) at /test/10.2_dbg/sql/sql_list.h:482

#9  0x00005582ef3e8f52 in TABLE_LIST::init_derived (this=this@entry=0x14d038013368, thd=thd@entry=0x14d038000d90, init_view=init_view@entry=false) at /test/10.2_dbg/sql/table.cc:8256

#10 0x00005582ef2d9801 in mysql_derived_prepare (thd=0x14d038000d90, lex=<optimized out>, derived=0x14d038013368) at /test/10.2_dbg/sql/sql_error.h:699

#11 0x00005582ef2da88e in mysql_handle_single_derived (lex=lex@entry=0x14d0380048c8, derived=derived@entry=0x14d038013368, phases=phases@entry=2) at /test/10.2_dbg/sql/sql_derived.cc:198

#12 0x00005582ef3e87e1 in TABLE_LIST::handle_derived (this=this@entry=0x14d038013368, lex=lex@entry=0x14d0380048c8, phases=phases@entry=2) at /test/10.2_dbg/sql/table.cc:8118

#13 0x00005582ef2f6a1d in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x14d0380048c8) at /test/10.2_dbg/sql/table.h:2427

#14 st_select_lex::handle_derived (this=<optimized out>, lex=0x14d0380048c8, phases=phases@entry=2) at /test/10.2_dbg/sql/sql_lex.cc:3930

#15 0x00005582ef36249a in JOIN::prepare (this=0x14d0380149f8, tables_init=0x14d038013368, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14d0380114a0, unit_arg=0x14d038011898) at /test/10.2_dbg/sql/sql_select.cc:716

#16 0x00005582ef5e50b7 in subselect_single_select_engine::prepare (this=0x14d038013b90, thd=0x14d038000d90) at /test/10.2_dbg/sql/sql_lex.h:986

#17 0x00005582ef5e4363 in Item_subselect::fix_fields (this=this@entry=0x14d038013990, thd_param=thd_param@entry=0x14d038000d90, ref=ref@entry=0x14d038013bd8) at /test/10.2_dbg/sql/item_subselect.cc:269

#18 0x00005582ef5e4914 in Item_in_subselect::fix_fields (this=0x14d038013990, thd_arg=0x14d038000d90, ref=0x14d038013bd8) at /test/10.2_dbg/sql/item_subselect.cc:3364

#19 0x00005582ef2aeb6d in setup_fields (thd=0x14d038000d90, ref_pointer_array=<optimized out>, fields=<optimized out>, mark_used_columns=mark_used_columns@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14d038014688, pre_fix=0x14d038005208, allow_sum_func=true) at /test/10.2_dbg/sql/sql_list.h:587

#20 0x00005582ef3629ef in JOIN::prepare (this=this@entry=0x14d038014368, tables_init=tables_init@entry=0x14d038013c50, wild_num=wild_num@entry=0, conds_init=conds_init@entry=0x0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14d0380050c8, unit_arg=0x14d038004988) at /test/10.2_dbg/sql/sql_select.cc:814

#21 0x00005582ef37585b in mysql_select (thd=thd@entry=0x14d038000d90, tables=0x14d038013c50, wild_num=0, fields=@0x14d0380051f0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14d038013bd0, last = 0x14d038013bd0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14d038014348, unit=0x14d038004988, select_lex=0x14d0380050c8) at /test/10.2_dbg/sql/sql_select.cc:3814

#22 0x00005582ef375b53 in handle_select (thd=thd@entry=0x14d038000d90, lex=lex@entry=0x14d0380048c8, result=result@entry=0x14d038014348, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.2_dbg/sql/sql_select.cc:361

#23 0x00005582ef2fa909 in execute_sqlcom_select (thd=thd@entry=0x14d038000d90, all_tables=0x14d038013c50) at /test/10.2_dbg/sql/sql_parse.cc:6247

#24 0x00005582ef30499d in mysql_execute_command (thd=thd@entry=0x14d038000d90) at /test/10.2_dbg/sql/sql_parse.cc:3558

#25 0x00005582ef30dea0 in mysql_parse (thd=thd@entry=0x14d038000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14d05b82c550, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.2_dbg/sql/sql_parse.cc:7762

#26 0x00005582ef3109d9 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14d038000d90, packet=packet@entry=0x14d0380195d1 "SELECT SHA(pk) IN (SELECT * FROM (SELECT '' FROM t) AS a) FROM t", packet_length=packet_length@entry=64, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.2_dbg/sql/sql_class.h:1096

#27 0x00005582ef3137e1 in do_command (thd=0x14d038000d90) at /test/10.2_dbg/sql/sql_parse.cc:1381

#28 0x00005582ef418a61 in do_handle_one_connection (connect=connect@entry=0x5582f1867410) at /test/10.2_dbg/sql/sql_connect.cc:1336

#29 0x00005582ef418c8c in handle_one_connection (arg=0x5582f1867410) at /test/10.2_dbg/sql/sql_connect.cc:1241

#30 0x000014d0a2dd5609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#31 0x000014d0a29cc293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95