CREATE TABLE t1 (

  v2 blob AS ('a' is null),

  a1 int,

  a char(1) AS (cast(a1 in (0,current_user() is null) as char(16777216) ))

);

INSERT IGNORE INTO t1 VALUES ('x','x',v2) ;

drop table t1;

#3  <signal handler called>

#4  0x000056539c3588f7 in Item_func_in::cleanup (this=0x7fed000a9c98) at /10.2/src/sql/item_cmpfunc.h:1673

#5  0x000056539bf2645d in Item::delete_self (this=0x7fed000a9c98) at /10.2/src/sql/item.h:1964

#6  0x000056539bf1cf30 in Query_arena::free_items (this=0x7fed00034ee0) at /10.2/src/sql/sql_class.cc:3555

#7  0x000056539c070918 in closefrm (table=0x7fed001767b0) at /10.2/src/sql/table.cc:3545

#8  0x000056539c15bfb0 in intern_close_table (table=0x7fed001767b0) at /10.2/src/sql/table_cache.cc:222

#9  0x000056539c15eacd in tdc_remove_table (thd=0x7fed00000d90, remove_type=TDC_RT_REMOVE_ALL, db=0x7fed00012de8 "test", table_name=0x7fed00012790 "t1", kill_delayed_threads=false) at /10.2/src/sql/table_cache.cc:1132

#10 0x000056539c02ad4c in mysql_rm_table_no_locks (thd=0x7fed00000d90, tables=0x7fed000127c8, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at /10.2/src/sql/sql_table.cc:2440

#11 0x000056539c02a106 in mysql_rm_table (thd=0x7fed00000d90, tables=0x7fed000127c8, if_exists=0 '\000', drop_temporary=0 '\000') at /10.2/src/sql/sql_table.cc:2093

#12 0x000056539bf659b0 in mysql_execute_command (thd=0x7fed00000d90) at /10.2/src/sql/sql_parse.cc:4556

#13 0x000056539bf6fa8c in mysql_parse (thd=0x7fed00000d90, rawbuf=0x7fed00012708 "drop table t1", length=13, parser_state=0x7fed58272560, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7793

#14 0x000056539bf5dce7 in dispatch_command (command=COM_QUERY, thd=0x7fed00000d90, packet=0x7fed00008b61 "drop table t1", packet_length=13, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827

#15 0x000056539bf5c7e2 in do_command (thd=0x7fed00000d90) at /10.2/src/sql/sql_parse.cc:1381

#16 0x000056539c0b83e9 in do_handle_one_connection (connect=0x56539e642c30) at /10.2/src/sql/sql_connect.cc:1336

#17 0x000056539c0b814e in handle_one_connection (arg=0x56539e642c30) at /10.2/src/sql/sql_connect.cc:1241

#18 0x000056539c8e225c in pfs_spawn_thread (arg=0x56539e626020) at /10.2/src/storage/perfschema/pfs.cc:1869

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

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

#3  <signal handler called>

#4  0x00005614142438f7 in Item_func_in::cleanup (this=0x7f6594035b58) at /10.2/src/sql/item_cmpfunc.h:1673

#5  0x0000561413e1145d in Item::delete_self (this=0x7f6594035b58) at /10.2/src/sql/item.h:1964

#6  0x0000561413e07f30 in Query_arena::free_items (this=0x7f65941765f0) at /10.2/src/sql/sql_class.cc:3555

#7  0x0000561413f5b918 in closefrm (table=0x7f65941756b0) at /10.2/src/sql/table.cc:3545

#8  0x000056141404e0fa in THD::close_temporary_table (this=0x7f6594000d90, table=0x7f65941756b0) at /10.2/src/sql/temporary_tables.cc:1235

#9  0x000056141404ec49 in THD::free_temporary_table (this=0x7f6594000d90, table=0x7f65941756b0) at /10.2/src/sql/temporary_tables.cc:1484

#10 0x000056141404cd03 in THD::drop_temporary_table (this=0x7f6594000d90, table=0x7f65941756b0, is_trans=0x7f65ec319350, delete_table=true) at /10.2/src/sql/temporary_tables.cc:651

#11 0x0000561413f157ec in mysql_rm_table_no_locks (thd=0x7f6594000d90, tables=0x7f65940127c8, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at /10.2/src/sql/sql_table.cc:2301

#12 0x0000561413f15106 in mysql_rm_table (thd=0x7f6594000d90, tables=0x7f65940127c8, if_exists=0 '\000', drop_temporary=0 '\000') at /10.2/src/sql/sql_table.cc:2093

#13 0x0000561413e509b0 in mysql_execute_command (thd=0x7f6594000d90) at /10.2/src/sql/sql_parse.cc:4556

#14 0x0000561413e5aa8c in mysql_parse (thd=0x7f6594000d90, rawbuf=0x7f6594012708 "drop table t1", length=13, parser_state=0x7f65ec31a560, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7793

#15 0x0000561413e48ce7 in dispatch_command (command=COM_QUERY, thd=0x7f6594000d90, packet=0x7f6594008b61 "drop table t1", packet_length=13, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827

#16 0x0000561413e477e2 in do_command (thd=0x7f6594000d90) at /10.2/src/sql/sql_parse.cc:1381

#17 0x0000561413fa33e9 in do_handle_one_connection (connect=0x561418029c30) at /10.2/src/sql/sql_connect.cc:1336

#18 0x0000561413fa314e in handle_one_connection (arg=0x561418029c30) at /10.2/src/sql/sql_connect.cc:1241

#19 0x00005614147cd25c in pfs_spawn_thread (arg=0x56141800d020) at /10.2/src/storage/perfschema/pfs.cc:1869

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

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

#4  0x000055828da2c763 in in_vector::find (this=0x7fa368013248, item=0x7fa3681770d8) at /10.2/src/sql/item_cmpfunc.cc:3642

#5  0x000055828da2f28a in Item_func_in::val_int (this=0x7fa368035b58) at /10.2/src/sql/item_cmpfunc.cc:4444

#6  0x000055828da5eadf in Item_int_func::val_str (this=0x7fa368035b58, str=0x7fa368035cd8) at /10.2/src/sql/item_func.cc:725

#7  0x000055828dad8863 in Item_char_typecast::val_str (this=0x7fa368035ca8, str=0x7fa368035cd8) at /10.2/src/sql/item_timefunc.cc:2509

#8  0x000055828da094cd in Item::save_in_field (this=0x7fa368035ca8, field=0x7fa3681764f0, no_conversions=false) at /10.2/src/sql/item.cc:6397

#9  0x000055828d876441 in TABLE::update_virtual_fields (this=0x7fa3681756b0, h=0x7fa368176718, update_mode=VCOL_UPDATE_FOR_READ) at /10.2/src/sql/table.cc:7795

#10 0x000055828d9e92f0 in handler::ha_rnd_next (this=0x7fa368176718, buf=0x7fa3681762c0 "\370") at /10.2/src/sql/handler.cc:2675

#11 0x000055828d9eaa52 in handler::read_first_row (this=0x7fa368176718, buf=0x7fa3681762c0 "\370", primary_key=64) at /10.2/src/sql/handler.cc:2904

#12 0x000055828d7e907b in handler::ha_read_first_row (this=0x7fa368176718, buf=0x7fa3681762c0 "\370", primary_key=64) at /10.2/src/sql/sql_class.h:5914

#13 0x000055828d7d0056 in join_read_system (tab=0x7fa368013b10) at /10.2/src/sql/sql_select.cc:19427

#14 0x000055828d7cfc0d in join_read_const_table (thd=0x7fa368000d90, tab=0x7fa368013b10, pos=0x7fa3680140c8) at /10.2/src/sql/sql_select.cc:19323

#15 0x000055828d7a96cf in make_join_statistics (join=0x7fa368012fe8, tables_list=..., keyuse_array=0x7fa3680132d8) at /10.2/src/sql/sql_select.cc:4175

#16 0x000055828d7a0a39 in JOIN::optimize_inner (this=0x7fa368012fe8) at /10.2/src/sql/sql_select.cc:1597

#17 0x000055828d79ef30 in JOIN::optimize (this=0x7fa368012fe8) at /10.2/src/sql/sql_select.cc:1127

#18 0x000055828d7a8486 in mysql_select (thd=0x7fa368000d90, tables=0x7fa3680128e0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa368012fc8, unit=0x7fa368004988, select_lex=0x7fa3680050d8) at /10.2/src/sql/sql_select.cc:3835

#19 0x000055828d79c66a in handle_select (thd=0x7fa368000d90, lex=0x7fa3680048c8, result=0x7fa368012fc8, setup_tables_done_option=0) at /10.2/src/sql/sql_select.cc:361

#20 0x000055828d766cd0 in execute_sqlcom_select (thd=0x7fa368000d90, all_tables=0x7fa3680128e0) at /10.2/src/sql/sql_parse.cc:6271

#21 0x000055828d75d844 in mysql_execute_command (thd=0x7fa368000d90) at /10.2/src/sql/sql_parse.cc:3582

#22 0x000055828d76aa8c in mysql_parse (thd=0x7fa368000d90, rawbuf=0x7fa368012708 "select * from t1", length=16, parser_state=0x7fa3bd128560, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7793

#23 0x000055828d758ce7 in dispatch_command (command=COM_QUERY, thd=0x7fa368000d90, packet=0x7fa368008b61 "select * from t1", packet_length=16, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827

#24 0x000055828d7577e2 in do_command (thd=0x7fa368000d90) at /10.2/src/sql/sql_parse.cc:1381

#25 0x000055828d8b33e9 in do_handle_one_connection (connect=0x5582901d39b0) at /10.2/src/sql/sql_connect.cc:1336

#26 0x000055828d8b314e in handle_one_connection (arg=0x5582901d39b0) at /10.2/src/sql/sql_connect.cc:1241

#27 0x000055828e0dd25c in pfs_spawn_thread (arg=0x5582901b6da0) at /10.2/src/storage/perfschema/pfs.cc:1869

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

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

CREATE TABLE `t1` (

  `v2` tinyblob GENERATED ALWAYS AS (current_user() is null is null) VIRTUAL,

  `v1` tinyint(3) unsigned zerofill DEFAULT NULL,

  `MEDIUM` char(1) CHARACTER SET utf8 COLLATE utf8_bin GENERATED ALWAYS AS (cast(`v1` in (0,current_user() is null is null,34) as char(16777216) charset binary) is not null) VIRTUAL,

  `t1` mediumint(8) unsigned zerofill NOT NULL COMMENT 'x',

  PRIMARY KEY (`t1`)

) ;

INSERT IGNORE INTO t1 VALUES 

( CONVERT ( 'x' LIKE v1 IS UNKNOWN , TIME ) , 'x' , 

  v2 IN ( v2 SOUNDS LIKE v1 IS FALSE ) IS UNKNOWN , 

  1 ) ;

select * from t1;

210730 17:07:32 [ERROR] mysqld got signal 11 ;

Server version: 10.3.31-MariaDB-debug-log

strings/decimal.c:1917(do_sub)[0x561d6e08e480]

strings/decimal.c:2046(decimal_cmp)[0x561d6e08f64f]

sql/my_decimal.h:500(my_decimal_cmp(my_decimal const*, my_decimal const*))[0x561d6c3bc440]

sql/item_cmpfunc.cc:3524(cmp_decimal(void*, my_decimal*, my_decimal*))[0x561d6ccf17a0]

sql/item_cmpfunc.cc:3539(in_vector::find(Item*))[0x561d6ccf19af]

sql/item_cmpfunc.cc:4442(Item_func_in::val_int())[0x561d6ccf97ea]

sql/item_func.cc:751(Item_int_func::val_str(String*))[0x561d6cd5cd84]

sql/item_timefunc.cc:2503(Item_char_typecast::val_str(String*))[0x561d6ceb9638]

sql/item_strfunc.h:72(Item_str_func::update_null_value())[0x561d6c46875b]

sql/item_func.h:185(Item_func::is_null())[0x561d6c3be80d]

sql/item_cmpfunc.cc:5215(Item_func_isnotnull::val_int())[0x561d6cd00d68]

sql/item.cc:6890(Item::save_int_in_field(Field*, bool))[0x561d6cc92d59]

sql/sql_type.cc:2593(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x561d6c9ac144]

sql/item.cc:6900(Item::save_in_field(Field*, bool))[0x561d6cc92f3d]

sql/table.cc:7991(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x561d6c7b5688]

sql/handler.cc:2866(handler::ha_rnd_next(unsigned char*))[0x561d6cc27e2e]

sql/records.cc:485(rr_sequential(READ_RECORD*))[0x561d6d022a35]

sql/records.h:70(READ_RECORD::read_record())[0x561d6c31053e]

sql/sql_select.cc:20781(join_init_read_record(st_join_table*))[0x561d6c5dcfbe]

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

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

sql/sql_select.cc:4142(JOIN::exec_inner())[0x561d6c567777]

sql/sql_select.cc:3937(JOIN::exec())[0x561d6c5650f4]

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

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

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

sql/sql_parse.cc:3870(mysql_execute_command(THD*))[0x561d6c49e8d8]

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

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

sql/sql_parse.cc:1398(do_command(THD*))[0x561d6c48e01a]

sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x561d6c85d82f]

sql/sql_connect.cc:1309(handle_one_connection)[0x561d6c85d0e9]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x561d6de89657]

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

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

Query (0x62b000000290): select * from t1

mariadbd: /10.6/src/strings/decimal.c:1082: ull2dec: Assertion `(to)->len >0 && ((to)->buf[0] | (to)->buf[(to)->len-1] | 1)' failed.

210730 17:15:50 [ERROR] mysqld got signal 6 ;

Server version: 10.6.4-MariaDB-debug-log

sql/signal_handler.cc:225(handle_fatal_signal)[0x5604516a0961]

sigaction.c:0(__restore_rt)[0x7f5a907c83c0]

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

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

intl/loadmsgcat.c:509(get_sysdep_segment_value)[0x7f5a90294729]

:0(__GI___assert_fail)[0x7f5a902a5f36]

strings/decimal.c:1084(ull2dec)[0x560452cd4477]

strings/decimal.c:1112(ulonglong2decimal)[0x560452cd486f]

sql/my_decimal.h:452(int2my_decimal(unsigned int, long long, char, my_decimal*))[0x5604513ef0ea]

sql/field.cc:2222(Field_int::val_decimal(my_decimal*))[0x560451615389]

sql/item.cc:3303(Item_field::val_decimal(my_decimal*))[0x560451714df4]

sql/item_cmpfunc.cc:3910(in_decimal::get_value(Item*))[0x560451792b49]

sql/item_cmpfunc.cc:3643(in_vector::find(Item*))[0x560451790265]

sql/item_cmpfunc.cc:4682(Item_func_in::val_int())[0x560451799d73]

sql/item_func.cc:752(Item_int_func::val_str(String*))[0x5604517f9e66]

sql/item_timefunc.cc:3172(Item_char_typecast::val_str_generic(String*))[0x560451968673]

sql/item_timefunc.cc:3276(Item_char_typecast_func_handler::val_str(Item_handled_func*, String*) const)[0x560451980942]

sql/item_func.h:771(Item_handled_func::val_str(String*))[0x56045147c3d2]

sql/sql_type.cc:4261(Type_handler_string_result::Item_update_null_value(Item*) const)[0x5604514482c3]

sql/item.h:2036(Item::update_null_value())[0x560450b7c77e]

sql/item_func.h:177(Item_func::is_null())[0x560450d410df]

sql/item_cmpfunc.cc:5571(Item_func_isnotnull::val_int())[0x5604517a0d7f]

sql/item.cc:6700(Item::save_int_in_field(Field*, bool))[0x56045172ffe9]

sql/sql_type.cc:4345(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x560451448ac6]

sql/item.cc:6710(Item::save_in_field(Field*, bool))[0x5604517301d5]

sql/table.cc:8704(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x5604511ddd0e]

sql/handler.cc:3399(handler::ha_rnd_next(unsigned char*))[0x5604516bc441]

sql/handler.cc:3629(handler::read_first_row(unsigned char*, unsigned int))[0x5604516c414f]

sql/sql_class.h:7333(handler::ha_read_first_row(unsigned char*, unsigned int))[0x560450fe69e0]

sql/sql_select.cc:21555(join_read_system(st_join_table*))[0x560450f9a5c9]

sql/sql_select.cc:21451(join_read_const_table(THD*, st_join_table*, POSITION*))[0x560450f99585]

sql/sql_select.cc:5407(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x560450f2689a]

sql/sql_select.cc:2452(JOIN::optimize_inner())[0x560450f085f4]

sql/sql_select.cc:1808(JOIN::optimize())[0x560450f0169a]

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

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

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

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

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

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

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

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

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

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

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

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

Query (0x62b0000a82a8): select * from t1