Assertion `fixed()' failed and Assertion `fixed == 1' failed, both in Item_func_concat::val_str on SELECT after INSERT with collation utf32_bin on utf8_bin table

SET sql_mode='';

CREATE TABLE t (c1 INT,c2 CHAR AS (CONCAT ('',DAYNAME ('')))) COLLATE utf8_bin ENGINE=InnoDB;

INSERT INTO t VALUES (0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0);

SET collation_connection='utf32_bin';

INSERT INTO t VALUES (0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0);

SELECT * FROM t;

mysqld: /test/10.9_dbg/sql/item_strfunc.cc:630: virtual String* Item_func_concat::val_str(String*): Assertion `fixed()' failed.

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

Program terminated with signal SIGABRT, Aborted.

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

[Current thread is 1 (Thread 0x14cc041a5700 (LWP 3968429))]

(gdb) bt

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

#1  0x000014cc23428859 in __GI_abort () at abort.c:79

#2  0x000014cc23428729 in __assert_fail_base (fmt=0x14cc235be588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55d7766c00bf "fixed()", file=0x55d776895c30 "/test/10.9_dbg/sql/item_strfunc.cc", line=630, function=<optimized out>) at assert.c:92

#3  0x000014cc23439f36 in __GI___assert_fail (assertion=assertion@entry=0x55d7766c00bf "fixed()", file=file@entry=0x55d776895c30 "/test/10.9_dbg/sql/item_strfunc.cc", line=line@entry=630, function=function@entry=0x55d776896d68 "virtual String* Item_func_concat::val_str(String*)") at assert.c:101

#4  0x000055d775e04e14 in Item_func_concat::val_str (this=0x14cbd0029ad0, str=0x14cbd0029af8) at /test/10.9_dbg/sql/item.h:1069

#5  0x000055d775d51ff1 in Item::save_str_in_field (this=0x14cbd0029ad0, field=0x14cbd0028620, no_conversions=<optimized out>) at /test/10.9_dbg/sql/item.cc:6763

#6  0x000055d775c2a060 in Type_handler_string_result::Item_save_in_field (this=<optimized out>, item=<optimized out>, field=<optimized out>, no_conversions=<optimized out>) at /test/10.9_dbg/sql/sql_type.cc:4343

#7  0x000055d775d3834d in Item::save_in_field (this=0x14cbd0029ad0, field=0x14cbd0028620, no_conversions=<optimized out>) at /test/10.9_dbg/sql/item.cc:6811

#8  0x000055d775b48f67 in TABLE::update_virtual_fields (this=0x14cbd00215e8, h=h@entry=0x14cbd00289a0, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.9_dbg/sql/table.cc:8757

#9  0x000055d775d2214b in handler::ha_rnd_next (this=0x14cbd00289a0, buf=0x14cbd0028518 <incomplete sequence \375>) at /test/10.9_dbg/sql/handler.cc:3408

#10 0x000055d775906f19 in rr_sequential (info=0x14cbd0016a08) at /test/10.9_dbg/sql/records.h:82

#11 0x000055d775a8b228 in READ_RECORD::read_record (this=0x14cbd0016a08) at /test/10.9_dbg/sql/records.h:81

#12 join_init_read_record (tab=0x14cbd0016940) at /test/10.9_dbg/sql/sql_select.cc:22089

#13 0x000055d775a72519 in sub_select (join=0x14cbd0015410, join_tab=0x14cbd0016940, end_of_records=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:21092

#14 0x000055d775aaa386 in do_select (procedure=0x0, join=0x14cbd0015410) at /test/10.9_dbg/sql/sql_select.cc:20640

#15 JOIN::exec_inner (this=this@entry=0x14cbd0015410) at /test/10.9_dbg/sql/sql_select.cc:4749

#16 0x000055d775aaa932 in JOIN::exec (this=this@entry=0x14cbd0015410) at /test/10.9_dbg/sql/sql_select.cc:4527

#17 0x000055d775aa8941 in mysql_select (thd=thd@entry=0x14cbd0000db8, tables=0x14cbd0014430, fields=@0x14cbd00140f8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14cbd00143e8, last = 0x14cbd0015c38, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14cbd00153e8, unit=0x14cbd00051c8, select_lex=0x14cbd0013e58) at /test/10.9_dbg/sql/sql_select.cc:5007

#18 0x000055d775aa8bf6 in handle_select (thd=thd@entry=0x14cbd0000db8, lex=lex@entry=0x14cbd00050f0, result=result@entry=0x14cbd00153e8, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.9_dbg/sql/sql_select.cc:543

#19 0x000055d775a08152 in execute_sqlcom_select (thd=thd@entry=0x14cbd0000db8, all_tables=0x14cbd0014430) at /test/10.9_dbg/sql/sql_parse.cc:6252

#20 0x000055d775a150b9 in mysql_execute_command (thd=thd@entry=0x14cbd0000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.9_dbg/sql/sql_parse.cc:3943

#21 0x000055d775a01343 in mysql_parse (thd=thd@entry=0x14cbd0000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14cc041a4400) at /test/10.9_dbg/sql/sql_parse.cc:8027

#22 0x000055d775a0ffdf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14cbd0000db8, packet=packet@entry=0x14cbd000b889 "", packet_length=packet_length@entry=15, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_class.h:1362

#23 0x000055d775a13426 in do_command (thd=0x14cbd0000db8, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:1402

#24 0x000055d775b8e036 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d7785c8388, put_in_cache=put_in_cache@entry=true) at /test/10.9_dbg/sql/sql_connect.cc:1418

#25 0x000055d775b8e63b in handle_one_connection (arg=arg@entry=0x55d7785c8388) at /test/10.9_dbg/sql/sql_connect.cc:1312

#26 0x000055d776014d23 in pfs_spawn_thread (arg=0x55d7784db5a8) at /test/10.9_dbg/storage/perfschema/pfs.cc:2201

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

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

mysqld: /test/10.5_dbg/sql/item_strfunc.cc:615: virtual String* Item_func_concat::val_str(String*): Assertion `fixed ==

 1' failed.

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

Program terminated with signal SIGABRT, Aborted.

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

[Current thread is 1 (Thread 0x14e230ce6700 (LWP 3968777))]

(gdb) bt

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

#1  0x000014e23b16c859 in __GI_abort () at abort.c:79

#2  0x000014e23b16c729 in __assert_fail_base (fmt=0x14e23b302588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55a7f8645e19 "fixed == 1", file=0x55a7f864a000 "/test/10.5_dbg/sql/item_strfunc.cc", line=615, function=<optimized out>) at assert.c:92

#3  0x000014e23b17df36 in __GI___assert_fail (assertion=assertion@entry=0x55a7f8645e19 "fixed == 1", file=file@entry=0x55a7f864a000 "/test/10.5_dbg/sql/item_strfunc.cc", line=line@entry=615, function=function@entry=0x55a7f864b0c0 "virtual String* Item_func_concat::val_str(String*)") at assert.c:101

#4  0x000055a7f7b4d716 in Item_func_concat::val_str (this=0x14e1ec0284b8, str=0x14e1ec0284f0) at /test/10.5_dbg/sql/item_strfunc.cc:615

#5  0x000055a7f7a92363 in Item::save_str_in_field (this=0x14e1ec0284b8, field=0x14e1ec026f98, no_conversions=<optimized out>) at /test/10.5_dbg/sql/item.cc:6719

#6  0x000055a7f796dac2 in Type_handler_string_result::Item_save_in_field (this=<optimized out>, item=<optimized out>, field=<optimized out>, no_conversions=<optimized out>) at /test/10.5_dbg/sql/sql_type.cc:4341

#7  0x000055a7f7a78505 in Item::save_in_field (this=0x14e1ec0284b8, field=0x14e1ec026f98, no_conversions=<optimized out>) at /test/10.5_dbg/sql/item.cc:6767

#8  0x000055a7f78a42f7 in TABLE::update_virtual_fields (this=0x14e1ec020db8, h=h@entry=0x14e1ec0272f0, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.5_dbg/sql/table.cc:8671

#9  0x000055a7f7a60a81 in handler::ha_rnd_next (this=0x14e1ec0272f0, buf=0x14e1ec026e88 <incomplete sequence \375>) at /test/10.5_dbg/sql/handler.cc:3095

#10 0x000055a7f7c3825d in rr_sequential (info=0x14e1ec016968) at /test/10.5_dbg/sql/records.h:81

#11 0x000055a7f77f2159 in READ_RECORD::read_record (this=0x14e1ec016968) at /test/10.5_dbg/sql/records.h:80

#12 join_init_read_record (tab=0x14e1ec0168a0) at /test/10.5_dbg/sql/sql_select.cc:21877

#13 0x000055a7f77d8958 in sub_select (join=0x14e1ec015388, join_tab=0x14e1ec0168a0, end_of_records=<optimized out>) at /test/10.5_dbg/sql/sql_select.cc:20910

#14 0x000055a7f78114cc in do_select (procedure=0x0, join=0x14e1ec015388) at /test/10.5_dbg/sql/sql_select.cc:20445

#15 JOIN::exec_inner (this=this@entry=0x14e1ec015388) at /test/10.5_dbg/sql/sql_select.cc:4538

#16 0x000055a7f7811a16 in JOIN::exec (this=this@entry=0x14e1ec015388) at /test/10.5_dbg/sql/sql_select.cc:4318

#17 0x000055a7f780fb9d in mysql_select (thd=thd@entry=0x14e1ec000db8, tables=0x14e1ec014378, fields=@0x14e1ec013eb8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14e1ec014330, last = 0x14e1ec015bc0, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14e1ec015360, unit=0x14e1ec004f60, select_lex=0x14e1ec013d68) at /test/10.5_dbg/sql/sql_select.cc:4795

#18 0x000055a7f780fe63 in handle_select (thd=thd@entry=0x14e1ec000db8, lex=lex@entry=0x14e1ec004e98, result=result@entry=0x14e1ec015360, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.5_dbg/sql/sql_select.cc:444

#19 0x000055a7f778147b in execute_sqlcom_select (thd=thd@entry=0x14e1ec000db8, all_tables=0x14e1ec014378) at /test/10.5_dbg/sql/sql_parse.cc:6314

#20 0x000055a7f778ebe0 in mysql_execute_command (thd=thd@entry=0x14e1ec000db8) at /test/10.5_dbg/sql/sql_parse.cc:4005

#21 0x000055a7f7779f5a in mysql_parse (thd=thd@entry=0x14e1ec000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14e230ce53d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8100

#22 0x000055a7f77897ad in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e1ec000db8, packet=packet@entry=0x14e1ec00b4a9 "", packet_length=packet_length@entry=15, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1290

#23 0x000055a7f778d029 in do_command (thd=0x14e1ec000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370

#24 0x000055a7f78e9d62 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55a7fb2860b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1418

#25 0x000055a7f78ea465 in handle_one_connection (arg=arg@entry=0x55a7fb2860b8) at /test/10.5_dbg/sql/sql_connect.cc:1312

#26 0x000055a7f7da3917 in pfs_spawn_thread (arg=0x55a7fb1be7b8) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201

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

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

mysqld: /test/10.2_dbg/sql/item_strfunc.cc:599: virtual String* Item_func_concat::val_str(String*): Assertion `fixed == 1' failed.

Core was generated by `/test/MD260222-mariadb-10.2.44-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 0x1467a742b700 (LWP 3969328))]

(gdb) bt

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

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

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

#3  <signal handler called>

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

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

#6  0x00001467e638d729 in __assert_fail_base (fmt=0x1467e6523588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c857d0d41e "fixed == 1", file=0x55c857d083d0 "/test/10.2_dbg/sql/item_strfunc.cc", line=599, function=<optimized out>) at assert.c:92

#7  0x00001467e639ef36 in __GI___assert_fail (assertion=assertion@entry=0x55c857d0d41e "fixed == 1", file=file@entry=0x55c857d083d0 "/test/10.2_dbg/sql/item_strfunc.cc", line=line@entry=599, function=function@entry=0x55c857d09490 "virtual String* Item_func_concat::val_str(String*)") at assert.c:101

#8  0x000055c857541621 in Item_func_concat::val_str (this=<optimized out>, str=<optimized out>) at /test/10.2_dbg/sql/item_strfunc.cc:610

#9  0x000055c8574a366f in Item::save_in_field (this=0x1467800251a0, field=0x146780023e60, no_conversions=<optimized out>) at /test/10.2_dbg/sql/item.cc:6441

#10 0x000055c8573610a9 in TABLE::update_virtual_fields (this=0x146780023150, h=h@entry=0x1467800241b8, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.2_dbg/sql/table.cc:7811

#11 0x000055c85748d774 in handler::ha_rnd_next (this=0x1467800241b8, buf=0x146780023d60 <incomplete sequence \375>) at /test/10.2_dbg/sql/handler.cc:2675

#12 0x000055c8575f8ce3 in rr_sequential (info=0x146780012f20) at /test/10.2_dbg/sql/records.cc:492

#13 0x000055c8572d7dbb in join_init_read_record (tab=0x146780012e58) at /test/10.2_dbg/sql/sql_select.cc:19840

#14 0x000055c8572c158f in sub_select (join=0x146780011a88, join_tab=0x146780012e58, end_of_records=<optimized out>) at /test/10.2_dbg/sql/sql_select.cc:18905

#15 0x000055c8572edea4 in do_select (procedure=0x0, join=0x146780011a88) at /test/10.2_dbg/sql/sql_select.cc:18451

#16 JOIN::exec_inner (this=this@entry=0x146780011a88) at /test/10.2_dbg/sql/sql_select.cc:3651

#17 0x000055c8572ee26e in JOIN::exec (this=this@entry=0x146780011a88) at /test/10.2_dbg/sql/sql_select.cc:3446

#18 0x000055c8572eec64 in mysql_select (thd=thd@entry=0x146780000d90, tables=0x146780011378, wild_num=1, fields=@0x146780005200: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x146780011330, last = 0x146780012220, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x146780011a68, unit=0x146780004988, select_lex=0x1467800050d8) at /test/10.2_dbg/sql/sql_select.cc:3849

#19 0x000055c8572eeef9 in handle_select (thd=thd@entry=0x146780000d90, lex=lex@entry=0x1467800048c8, result=result@entry=0x146780011a68, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.2_dbg/sql/sql_select.cc:361

#20 0x000055c857273839 in execute_sqlcom_select (thd=thd@entry=0x146780000d90, all_tables=0x146780011378) at /test/10.2_dbg/sql/sql_parse.cc:6271

#21 0x000055c85727dac4 in mysql_execute_command (thd=thd@entry=0x146780000d90) at /test/10.2_dbg/sql/sql_parse.cc:3582

#22 0x000055c8572872cc in mysql_parse (thd=thd@entry=0x146780000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1467a742a540, 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:7793

#23 0x000055c857289dcf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x146780000d90, packet=packet@entry=0x1467800195e1 "", packet_length=packet_length@entry=15, 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:1109

#24 0x000055c85728cbd2 in do_command (thd=0x146780000d90) at /test/10.2_dbg/sql/sql_parse.cc:1381

#25 0x000055c857391e00 in do_handle_one_connection (connect=connect@entry=0x55c859743580) at /test/10.2_dbg/sql/sql_connect.cc:1336

#26 0x000055c85739202b in handle_one_connection (arg=0x55c859743580) at /test/10.2_dbg/sql/sql_connect.cc:1241

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

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