[Draft] Yet another Assertion `typeid(*copy) == typeid(*this)'

CREATE TABLE t4 (col_timestamp TIMESTAMP(4) NULL, col_char CHAR(224) NULL, id BIGINT /*!100303 */, col_int MEDIUMINT(32) NULL, col_enum ENUM('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '', col_year YEAR NULL, col_time TIME(2) NULL, col_datetime DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00');

CREATE ALGORITHM=TEMPTABLE VIEW view_t4_temptable AS SELECT * FROM t4;

EXECUTE IMMEDIATE "SELECT DISTINCT STDDEV_SAMP((col_char & \'1921-09-30 08:48:03.033551\')) AS field1 FROM view_t4_temptable WHERE (COERCIBILITY((AES_DECRYPT(NULL, (/*!100303 VALUE(col_int) */))))) > ((MD5(\'avaqoehrbuopmgotgoglocbnpmhczapuhepmxusmlnfvxlyuxamxqxmalyzzvguqkuh\')) - col_int) GROUP BY LOG((RAND(1250623488)), 20320613185704.027473) ORDER BY SQRT((DECODE(NULL, NULL))), CAST((ELT((@A := \'1953-03-11\'), \'13:09:44.065338\', (- \'00:21:09.014202\'), \'3f:6:0f:a6ed:57ce:c:f::\', col_year)) AS DATETIME)";

#9  0x00007fa985645395 in __assert_fail_base (fmt=0x7fa9857b9a90 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a4dc4f8540 "typeid(*copy) == typeid(*this)", file=file@entry=0x55a4dc4f7760 "/data/bld/10.6-asan-ubsan/sql/item.h", line=line@entry=1903, function=function@entry=0x55a4dc4f8580 "Item* Item::get_copy(THD*) const") at ./assert/assert.c:92

#10 0x00007fa985653eb2 in __GI___assert_fail (assertion=0x55a4dc4f8540 "typeid(*copy) == typeid(*this)", file=0x55a4dc4f7760 "/data/bld/10.6-asan-ubsan/sql/item.h", line=1903, function=0x55a4dc4f8580 "Item* Item::get_copy(THD*) const") at ./assert/assert.c:101

#11 0x000055a4d87cbb51 in Item::get_copy (this=this@entry=0x62d000265818, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:1903

#12 0x000055a4d8924b60 in Item_field::do_build_clone (this=0x62d000265818, thd=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:3883

#13 0x000055a4d8b6eb1a in Item::build_clone (this=this@entry=0x62d000265818, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:1917

#14 0x000055a4da0183a2 in Item_func_or_sum::do_build_clone (this=0x62d000265998, thd=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/item.cc:2817

#15 0x000055a4d8b6eb1a in Item::build_clone (this=this@entry=0x62d000265998, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:1917

#16 0x000055a4da0183a2 in Item_func_or_sum::do_build_clone (this=0x62d000265b28, thd=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/item.cc:2817

#17 0x000055a4d8b6eb1a in Item::build_clone (this=this@entry=0x62d000265b28, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:1917

#18 0x000055a4da0183a2 in Item_func_or_sum::do_build_clone (this=this@entry=0x62d000266160, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.cc:2817

#19 0x000055a4da1ca222 in Item_bool_rowready_func2::do_build_clone (this=0x62d000266160, thd=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item_cmpfunc.h:619

#20 0x000055a4d8b6eb1a in Item::build_clone (this=this@entry=0x62d000266160, thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/item.h:1917

#21 0x000055a4da07ffdc in Item::build_pushable_cond (this=this@entry=0x62d000266160, thd=thd@entry=0x62b00007e218, checker=<optimized out>, arg=arg@entry=0x62d0002806e0 "\001") at /data/bld/10.6-asan-ubsan/sql/item.cc:7938

#22 0x000055a4d8b669d0 in pushdown_cond_for_derived (thd=<optimized out>, cond=<optimized out>, derived=derived@entry=0x62d000264ec8) at /data/bld/10.6-asan-ubsan/sql/sql_derived.cc:1544

#23 0x000055a4d9033a53 in JOIN::optimize_inner (this=this@entry=0x62d00005c5c0) at /data/bld/10.6-asan-ubsan/sql/sql_select.cc:2426

#24 0x000055a4d9036ff6 in JOIN::optimize (this=this@entry=0x62d00005c5c0) at /data/bld/10.6-asan-ubsan/sql/sql_select.cc:1927

#25 0x000055a4d9037d31 in mysql_select (thd=thd@entry=0x62b00007e218, tables=<optimized out>, fields=..., conds=conds@entry=0x62d000266160, og_num=og_num@entry=3, order=order@entry=0x62d000267648, group=<optimized out>, having=<optimized out>, proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_select.cc:5182

#26 0x000055a4d903922a in handle_select (thd=thd@entry=0x62b00007e218, lex=lex@entry=0x62d000262438, result=result@entry=0x62d000268180, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/10.6-asan-ubsan/sql/sql_select.cc:573

#27 0x000055a4d8d300b2 in execute_sqlcom_select (thd=thd@entry=0x62b00007e218, all_tables=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:6422

#28 0x000055a4d8d73b3c in mysql_execute_command (thd=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:4013

#29 0x000055a4d8e2e6b2 in Prepared_statement::execute (this=this@entry=0x61900005af98, expanded_query=expanded_query@entry=0x7fa97b639a70, open_cursor=open_cursor@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_prepare.cc:5274

#30 0x000055a4d8e321c6 in Prepared_statement::execute_loop (this=this@entry=0x61900005af98, expanded_query=expanded_query@entry=0x7fa97b639a70, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /data/bld/10.6-asan-ubsan/sql/sql_prepare.cc:4680

#31 0x000055a4d8e3594a in Prepared_statement::execute_immediate (this=this@entry=0x61900005af98, query=<optimized out>, query_len=<optimized out>) at /data/bld/10.6-asan-ubsan/sql/sql_prepare.cc:5425

#32 0x000055a4d8e3654e in mysql_sql_stmt_execute_immediate (thd=thd@entry=0x62b00007e218) at /data/bld/10.6-asan-ubsan/sql/sql_prepare.cc:3118

#33 0x000055a4d8d73ba0 in mysql_execute_command (thd=thd@entry=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:4019

#34 0x000055a4d8d95a56 in mysql_parse (thd=thd@entry=0x62b00007e218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fa97b63aac0) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:8200

#35 0x000055a4d8d9ed26 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00007e218, packet=packet@entry=0x62900024e219 "EXECUTE IMMEDIATE \"SELECT DISTINCT STDDEV_SAMP((col_char & \\'1921-09-30 08:48:03.033551\\')) AS field1 FROM view_t4_temptable WHERE (COERCIBILITY((AES_DECRYPT(NULL, (/*!100303 VALUE(col_int) */))))) > "..., packet_length=packet_length@entry=517, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1908

#36 0x000055a4d8dab978 in do_command (thd=thd@entry=0x62b00007e218, blocking=blocking@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_parse.cc:1421

#37 0x000055a4d952da12 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002f38, put_in_cache=put_in_cache@entry=true) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1386

#38 0x000055a4d952eb6f in handle_one_connection (arg=0x608000002f38) at /data/bld/10.6-asan-ubsan/sql/sql_connect.cc:1298

#39 0x000055a4daf598b9 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.6-asan-ubsan/storage/perfschema/pfs.cc:2201

#40 0x00007fa9856a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#41 0x00007fa98572885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81