CREATE TABLE t1 ( c0 date) ;

CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;

SELECT c0  FROM v1 WHERE  c0 IN ( 'a', 'b', 'c' )  ;

Version: '10.6.19-MariaDB-debug-log'  

mariadbd: /git/10.6/sql/item.h:1885: Item* Item::get_copy(THD*) const: Assertion `typeid(*copy) == typeid(*this)' failed.

240801 21:32:34 [ERROR] mysqld got signal 6 ;

Server version: 10.6.19-MariaDB-debug-log source revision: 534524297d5171d638a7c0e9f1f446cab1311845

/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f42d1262fd6]

sql/item.h:1887(Item::get_copy(THD*) const)[0x5566f6541eab]

sql/item.h:5263(Item_date_literal::do_build_clone(THD*) const)[0x5566f709aeb9]

sql/item.h:1899(Item::build_clone(THD*) const)[0x5566f673e463]

sql/item_cmpfunc.cc:7902(Item_equal::create_pushable_equalities(THD*, List<Item>*, bool (Item::*)(unsigned char*), unsigned char*, bool))[0x5566f71dcb70]

sql/item.cc:7847(Item::build_pushable_cond(THD*, bool (Item::*)(unsigned char*), unsigned char*))[0x5566f715cc3c]

sql/sql_derived.cc:1544(pushdown_cond_for_derived(THD*, Item*, TABLE_LIST*))[0x5566f673cce8]

sql/sql_select.cc:2407(JOIN::optimize_inner())[0x5566f68ea321]

sql/sql_select.cc:1913(JOIN::optimize())[0x5566f68e4c7d]

sql/sql_select.cc:5158(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5566f69070bc]

sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5566f68d60cf]

sql/sql_parse.cc:6380(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5566f68355c6]

sql/sql_parse.cc:3988(mysql_execute_command(THD*, bool))[0x5566f68239f4]

sql/sql_parse.cc:8165(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5566f684079c]

sql/sql_parse.cc:1899(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5566f6815cc9]

sql/sql_parse.cc:1410(do_command(THD*, bool))[0x5566f6812a0a]

sql/sql_connect.cc:1417(do_handle_one_connection(CONNECT*, bool))[0x5566f6c9d511]

sql/sql_connect.cc:1321(handle_one_connection)[0x5566f6c9ce6e]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5566f793d722]

nptl/pthread_create.c:478(start_thread)[0x7f42d177d609]

Query (0x62b0000852a8): SELECT c0  FROM v1 WHERE  c0 IN ( 'a', 'b', 'c' )