Assertion `typeid(*copy) == typeid(*this)' failed in Item::get_copy and Item::shallow_copy_with_checks upon INSERT

--source include/have_innodb.inc

CREATE TABLE t (c YEAR KEY) ENGINE=InnoDB;

INSERT INTO t VALUES ((c IN (SELECT * FROM (SELECT * FROM t GROUP BY c) AS d NATURAL JOIN (SELECT * FROM t) AS e)));

DROP TABLE t;  # Cleanup

mariadbd: /test/12.3_dbg/sql/item.h:1918: Item *Item::get_copy(THD *) const: Assertion `typeid(*copy) == typeid(*this)' failed.

Core was generated by `/test/MD050226-mariadb-12.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2491881)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x0000733bbc24526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x0000733bbc2288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x0000733bbc22881b in __assert_fail_base (fmt=0x733bbc3d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6370d223071c "typeid(*copy) == typeid(*this)", file=file@entry=0x6370d22a02ad "/test/12.3_dbg/sql/item.h", line=line@entry=1918, function=function@entry=0x6370d2181fd4 "Item *Item::get_copy(THD *) const")at ./assert/assert.c:94

#6  0x0000733bbc23b507 in __assert_fail (assertion=0x6370d223071c "typeid(*copy) == typeid(*this)", file=0x6370d22a02ad "/test/12.3_dbg/sql/item.h", line=1918, function=0x6370d2181fd4 "Item *Item::get_copy(THD *) const")at ./assert/assert.c:103

#7  0x00006370d2a72763 in Item::get_copy (this=0x733a900805d0, thd=0x733a90000d58) at /test/12.3_dbg/sql/item.h:1918

#8  0x00006370d322d54d in Item_cache_year::do_build_clone (this=0x733a900805d0, thd=0x733a90000d58) at /test/12.3_dbg/sql/item.h:7885

#9  0x00006370d2afefa5 in Item::build_clone (this=0x733a900805d0, thd=0x733a90000d58) at /test/12.3_dbg/sql/item.h:1932

#10 0x00006370d2b16390 in Item_ref::do_build_clone (this=0x733a90080680, thd=0x733a90000d58) at /test/12.3_dbg/sql/item.cc:3237

#11 0x00006370d2afefa5 in Item::build_clone (this=0x733a90080680, thd=0x733a90000d58) at /test/12.3_dbg/sql/item.h:1932

#12 0x00006370d3256588 in TABLE::add_splitting_info_for_key_field (this=0x733a90087020, key_field=0x733a90084910)at /test/12.3_dbg/sql/opt_split.cc:650

#13 0x00006370d2fd8bb9 in add_key_part (keyuse_array=0x733bb05fad90, key_field=0x733a90084910) at /test/12.3_dbg/sql/sql_select.cc:7489

#14 0x00006370d2fccee2 in update_ref_and_keys (thd=0x733a90000d58, keyuse=0x733bb05fad90, join_tab=0x733a90081c38, tables=2, cond=0x733a900846d8, normal_tables=18446744073709551615, select_lex=0x733a9001add8, sargables=0x733bb05fad88)at /test/12.3_dbg/sql/sql_select.cc:7831

#15 0x00006370d2fcc7f4 in JOIN::reoptimize (this=0x733a90021098, added_where=0x733a900846d8, join_tables=3, save_to=0x733bb05fb078)at /test/12.3_dbg/sql/sql_select.cc:32827

#16 0x00006370d3199ccd in JOIN::choose_subquery_plan (this=0x733a90021098, join_tables=3) at /test/12.3_dbg/sql/opt_subselect.cc:6868

#17 0x00006370d2f8f835 in make_join_statistics (join=0x733a90021098, tables_list=@0x733a9001aff0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x733a9007fca8, last = 0x733a9007fcb8, elements = 2}, <No data fields>}, keyuse_array=0x733a900213f8) at /test/12.3_dbg/sql/sql_select.cc:6422

#18 0x00006370d2f87692 in JOIN::optimize_inner (this=0x733a90021098)at /test/12.3_dbg/sql/sql_select.cc:2763

#19 0x00006370d2f85366 in JOIN::optimize (this=0x733a90021098)at /test/12.3_dbg/sql/sql_select.cc:2016

#20 0x00006370d2ed69b6 in st_select_lex::optimize_unflattened_subqueries (this=0x733a9001a7b8, const_only=false)at /test/12.3_dbg/sql/sql_lex.cc:5129

#21 0x00006370d2eb9f49 in mysql_insert (thd=0x733a90000d58, table_list=0x733a9001a078, fields=@0x733a90006110: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6370d3fcbb40 <end_of_list>, last = 0x733a90006110, elements = 0}, <No data fields>}, values_list=@0x733a90006158: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x733a90020500, last = 0x733a90020500, elements = 1}, <No data fields>}, update_fields=@0x733a90006140: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6370d3fcbb40 <end_of_list>, last = 0x733a90006140, elements = 0}, <No data fields>}, update_values=@0x733a90006128: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6370d3fcbb40 <end_of_list>, last = 0x733a90006128, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0)at /test/12.3_dbg/sql/sql_insert.cc:923

#22 0x00006370d2f1eb28 in mysql_execute_command (thd=0x733a90000d58, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:4483

#23 0x00006370d2f15a58 in mysql_parse (thd=0x733a90000d58, rawbuf=0x733a90019ee0 "INSERT INTO t VALUES ((c IN (SELECT * FROM (SELECT * FROM t GROUP BY c) AS d NATURAL JOIN (SELECT * FROM t) AS e)))", length=115, parser_state=0x733bb05fda00) at /test/12.3_dbg/sql/sql_parse.cc:7950

#24 0x00006370d2f1320e in dispatch_command (command=COM_QUERY, thd=0x733a90000d58, packet=0x733a9000b239 "INSERT INTO t VALUES ((c IN (SELECT * FROM (SELECT * FROM t GROUP BY c) AS d NATURAL JOIN (SELECT * FROM t) AS e)))", packet_length=115, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1896

#25 0x00006370d2f164da in do_command (thd=0x733a90000d58, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1432

#26 0x00006370d310e42e in do_handle_one_connection (connect=0x6370d6b48e08, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503

#27 0x00006370d310e211 in handle_one_connection (arg=0x6370d6a855c8)at /test/12.3_dbg/sql/sql_connect.cc:1415

#28 0x0000733bbc29ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#29 0x0000733bbc329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

mariadbd: /test/10.6_dbg/sql/item.h:1903: Item *Item::shallow_copy_with_checks(THD *) const: Assertion `typeid(*copy) == typeid(*this)' failed.

Core was generated by `/test/MD230126-mariadb-10.6.25-linux-x86_64-dbg/bin/mariadbd --no-defaults --ma'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 1743796)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x000070da57c4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000070da57c288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000070da57c2881b in __assert_fail_base (fmt=0x70da57dd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6193bc8af715 "typeid(*copy) == typeid(*this)", file=file@entry=0x6193bc8fcff1 "/test/10.6_dbg/sql/item.h", line=line@entry=1903, function=function@entry=0x6193bc89509b "Item *Item::shallow_copy_with_checks(THD *) const") at ./assert/assert.c:94

#6  0x000070da57c3b507 in __assert_fail (assertion=0x6193bc8af715 "typeid(*copy) == typeid(*this)", file=0x6193bc8fcff1 "/test/10.6_dbg/sql/item.h", line=1903, function=0x6193bc89509b "Item *Item::shallow_copy_with_checks(THD *) const") at ./assert/assert.c:103

#7  0x00006193bcf75143 in Item::shallow_copy_with_checks (this=0x70d94807fb60, thd=0x70d948000d58) at /test/10.6_dbg/sql/item.h:1903

#8  0x00006193bd5fdb7d in Item_cache_year::deep_copy (this=0x70d94807fb60, thd=0x70d948000d58) at /test/10.6_dbg/sql/item.h:7650

#9  0x00006193bcfa6525 in Item::deep_copy_with_checks (this=0x70d94807fb60, thd=0x70d948000d58) at /test/10.6_dbg/sql/item.h:1917

#10 0x00006193bcff6b40 in Item_ref::deep_copy (this=0x70d94807fc00, thd=0x70d948000d58) at /test/10.6_dbg/sql/item.cc:3133

#11 0x00006193bcfa6525 in Item::deep_copy_with_checks (this=0x70d94807fc00, thd=0x70d948000d58) at /test/10.6_dbg/sql/item.h:1917

#12 0x00006193bd624078 in TABLE::add_splitting_info_for_key_field (this=0x70d948076ac0, key_field=0x70d948083128)at /test/10.6_dbg/sql/opt_split.cc:606

#13 0x00006193bd3f7270 in add_key_part (keyuse_array=0x70da54565530, key_field=0x70d948083128) at /test/10.6_dbg/sql/sql_select.cc:7099

#14 0x00006193bd3ed440 in update_ref_and_keys (thd=0x70d948000d58, keyuse=0x70da54565530, join_tab=0x70d948080d60, tables=2, cond=0x70d948082f00, normal_tables=18446744073709551615, select_lex=0x70d948014208, sargables=0x70da54565528)at /test/10.6_dbg/sql/sql_select.cc:7441

#15 0x00006193bd3ecd64 in JOIN::reoptimize (this=0x70d94801a180, added_where=0x70d948082f00, join_tables=3, save_to=0x70da54565728)at /test/10.6_dbg/sql/sql_select.cc:30553

#16 0x00006193bd593ada in JOIN::choose_subquery_plan (this=0x70d94801a180, join_tables=3) at /test/10.6_dbg/sql/opt_subselect.cc:6642

#17 0x00006193bd3b3b2d in make_join_statistics (join=0x70d94801a180, tables_list=@0x70d948014428: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x70d94807f2a0, last = 0x70d94807f2b0, elements = 2}, <No data fields>}, keyuse_array=0x70d94801a4b0) at /test/10.6_dbg/sql/sql_select.cc:6161

#18 0x00006193bd3ae62f in JOIN::optimize_inner (this=0x70d94801a180)at /test/10.6_dbg/sql/sql_select.cc:2613

#19 0x00006193bd3aa2f0 in JOIN::optimize (this=0x70d94801a180)at /test/10.6_dbg/sql/sql_select.cc:1927

#20 0x00006193bd312b36 in st_select_lex::optimize_unflattened_subqueries (this=0x70d948013c00, const_only=false)at /test/10.6_dbg/sql/sql_lex.cc:5027

#21 0x00006193bd2f747f in mysql_insert (thd=0x70d948000d58, table_list=0x70d9480134f8, fields=@0x70d948005e68: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6193be262080 <end_of_list>, last = 0x70d948005e68, elements = 0}, <No data fields>}, values_list=@0x70d948005eb0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x70d948019680, last = 0x70d948019680, elements = 1}, <No data fields>}, update_fields=@0x70d948005e98: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6193be262080 <end_of_list>, last = 0x70d948005e98, elements = 0}, <No data fields>}, update_values=@0x70d948005e80: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6193be262080 <end_of_list>, last = 0x70d948005e80, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0)at /test/10.6_dbg/sql/sql_insert.cc:857

#22 0x00006193bd34935b in mysql_execute_command (thd=0x70d948000d58, is_called_from_prepared_stmt=false) at /test/10.6_dbg/sql/sql_parse.cc:4635

#23 0x00006193bd33fba8 in mysql_parse (thd=0x70d948000d58, rawbuf=0x70d948013360 "INSERT INTO t VALUES ((c IN (SELECT * FROM (SELECT * FROM t GROUP BY c) AS d NATURAL JOIN (SELECT * FROM t) AS e)))", length=115, parser_state=0x70da54567a48) at /test/10.6_dbg/sql/sql_parse.cc:8201

#24 0x00006193bd33d45a in dispatch_command (command=COM_QUERY, thd=0x70d948000d58, packet=0x70d94800ade9 "INSERT INTO t VALUES ((c IN (SELECT * FROM (SELECT * FROM t GROUP BY c) AS d NATURAL JOIN (SELECT * FROM t) AS e)))", packet_length=115, blocking=true) at /test/10.6_dbg/sql/sql_parse.cc:1911

#25 0x00006193bd34062a in do_command (thd=0x70d948000d58, blocking=true)at /test/10.6_dbg/sql/sql_parse.cc:1421

#26 0x00006193bd515fae in do_handle_one_connection (connect=0x6193c01e49d8, put_in_cache=true) at /test/10.6_dbg/sql/sql_connect.cc:1386

#27 0x00006193bd515d95 in handle_one_connection (arg=0x6193c02b3478)at /test/10.6_dbg/sql/sql_connect.cc:1298

#28 0x000070da57c9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#29 0x000070da57d29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.6   dbg  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  typeid(*copy) == typeid(*this)|SIGABRT|Item::shallow_copy_with_checks|Item_cache_year::deep_copy|Item::deep_copy_with_checks|Item_ref::deep_copy

CS  10.6   opt  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  No bug found                  

CS  10.11  dbg  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

CS  10.11  opt  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  No bug found                  

CS  11.4   dbg  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

CS  11.4   opt  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  No bug found                  

CS  11.8   dbg  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

CS  11.8   opt  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  No bug found                  

CS  12.2   dbg  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

CS  12.2   opt  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  No bug found                  

CS  12.3   dbg  050226  fa36b269f139252b81d4384fbed07b167855cabb  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

CS  12.3   opt  050226  fa36b269f139252b81d4384fbed07b167855cabb  No bug found                  

ES  10.6   dbg  230126  0fe345fff3a0463224ca714831303d40fb83648b  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

ES  10.6   opt  230126  0fe345fff3a0463224ca714831303d40fb83648b  No bug found                  

ES  11.4   dbg  230126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

ES  11.4   opt  230126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  No bug found                  

ES  11.8   dbg  230126  405ee76b60c4ab82155f339136ed20d3b7363717  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item_cache_year::do_build_clone|Item::build_clone|Item_ref::do_build_clone

ES  11.8   opt  230126  405ee76b60c4ab82155f339136ed20d3b7363717  No bug found                  

MS  5.5    dbg  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  

MS  5.5    opt  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  

MS  5.6    dbg  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  

MS  5.6    opt  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  

MS  5.7    dbg  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  

MS  5.7    opt  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  

MS  8.0    dbg  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  

MS  8.0    opt  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  

MS  9.1    dbg  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  

MS  9.1    opt  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.6   dbg  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  typeid(*copy) == typeid(*this)|SIGABRT|Item::shallow_copy_with_checks|Item::deep_copy_with_checks|Item_ref::deep_copy|Item::deep_copy_with_checks

CS  10.6   opt  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  No bug found                  

CS  10.11  dbg  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

CS  10.11  opt  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  No bug found                  

CS  11.4   dbg  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone            

CS  11.4   opt  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  No bug found                  

CS  11.8   dbg  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

CS  11.8   opt  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  No bug found                  

CS  12.2   dbg  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

CS  12.2   opt  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  No bug found                  

CS  12.3   dbg  050226  fa36b269f139252b81d4384fbed07b167855cabb  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

CS  12.3   opt  050226  fa36b269f139252b81d4384fbed07b167855cabb  No bug found                  

ES  10.6   dbg  260126  0fe345fff3a0463224ca714831303d40fb83648b  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

ES  10.6   opt  230126  0fe345fff3a0463224ca714831303d40fb83648b  No bug found                  

ES  11.4   dbg  260126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

ES  11.4   opt  260126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  No bug found                  

ES  11.8   dbg  230126  405ee76b60c4ab82155f339136ed20d3b7363717  typeid(*copy) == typeid(*this)|SIGABRT|Item::get_copy|Item::build_clone|Item_ref::do_build_clone|Item::build_clone

ES  11.8   opt  230126  405ee76b60c4ab82155f339136ed20d3b7363717  No bug found