--source include/have_innodb.inc

 CREATE TABLE t1 ( 

	id int, 

	dt1 date, 

	i1 int,

	v_i1 int GENERATED ALWAYS AS (i1), 

	PRIMARY KEY (id,i1),

	KEY i1 (i1),

	KEY v_i1 (v_i1)

) ENGINE=InnoDB;

INSERT INTO t1(dt1, i1, id) VALUES  

('1994-04-27',3,1),('1939-03-07',8,2),('2035-04-15',195,3),('1936-02-07',8,4),('1912-08-14',9,5);

SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0);

Version: '10.5.10-MariaDB-debug-log' 

mariadbd: /10.5/storage/innobase/row/row0sel.cc:2846: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed.

210505 12:57:05 [ERROR] mysqld got signal 6 ;

linux/raise.c:51(__GI_raise)[0x7f7ea79f87bb]

stdlib/abort.c:81(__GI_abort)[0x7f7ea79e3535]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f7ea79e340f]

??:0(__assert_fail)[0x7f7ea79f1102]

row/row0sel.cc:2848(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x5654c1ab8538]

row/row0sel.cc:3001(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x5654c1ab98a8]

row/row0sel.cc:3965(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x5654c1abf0be]

row/row0sel.cc:5281(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5654c1ac8678]

handler/ha_innodb.cc:8854(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5654c16a12fe]

sql/handler.h:3809(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0bd6001]

sql/handler.cc:3123(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0ba6bf5]

sql/handler.cc:6200(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x5654c0bc1454]

sql/multi_range_read.cc:516(handler::multi_range_read_next(void**))[0x5654c08a9484]

sql/multi_range_read.cc:553(Mrr_simple_index_reader::get_next(void**))[0x5654c08a9858]

sql/multi_range_read.cc:1653(DsMrr_impl::dsmrr_next(void**))[0x5654c08b3237]

handler/ha_innodb.cc:20409(ha_innobase::multi_range_read_next(void**))[0x5654c16d370c]

sql/opt_range.cc:12647(QUICK_RANGE_SELECT::get_next())[0x5654c0fb3f8d]

sql/records.cc:403(rr_quick(READ_RECORD*))[0x5654c0fe8107]

sql/records.h:80(READ_RECORD::read_record())[0x5654c01fbf5a]

sql/sql_select.cc:21766(join_init_read_record(st_join_table*))[0x5654c04ff80f]

sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5654c04f8af7]

sql/sql_select.cc:20355(do_select(JOIN*, Procedure*))[0x5654c04f6e52]

sql/sql_select.cc:4503(JOIN::exec_inner())[0x5654c04843ae]

sql/sql_select.cc:4284(JOIN::exec())[0x5654c04819fc]

sql/sql_select.cc:4761(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*))[0x5654c0485c9d]

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

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

sql/sql_parse.cc:4009(mysql_execute_command(THD*))[0x5654c03b3585]

sql/sql_parse.cc:8099(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5654c03cf460]

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

sql/sql_parse.cc:1370(do_command(THD*))[0x5654c03a21e5]

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

sql/sql_connect.cc:1314(handle_one_connection)[0x5654c07d44c3]

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

nptl/pthread_create.c:487(start_thread)[0x7f7ea7eb1fa3]

x86_64/clone.S:97(clone)[0x7f7ea7aba4cf]

Query (0x62b0000a12a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)