--source include/have_innodb.inc

CREATE TABLE t1 (f1 int, f2 int, f3 varchar(1024), 

	v2 int AS (f1 + 1) , 

	v3 double AS (f1 + f2) , 

	v4 varchar(64) AS (CASE WHEN f2 = 0 THEN 0 ELSE f1 + 1 END) , 

	KEY idx3 (v3)) engine=innodb;

INSERT INTO t1 (f1,f2,f3) values (5,13,8),(5,13,9);

--connect (a1,127.0.0.1,root,,test)

--connection a1 

--send 

 SELECT 1 FROM t1 WHERE v2 +v3 <=> f3 AND v3 < 7 ORDER BY v4;

--connection default

UPDATE  t1 SET f2 = 1 WHERE v4 <=> 6;

--connection a1

--reap

10.5/src/sql/field.cc:7892: virtual double Field_varstring::val_real(): Assertion `marked_for_read()' failed.

Server version: 10.5.28-MariaDB-debug-log source revision: 0d35fe6e5761cbee731ffcac55f2bf8eaf2a6a8f

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

sql/field.cc:7893(Field_varstring::val_real())[0x5621e4f3cb5a]

sql/item.cc:3362(Item_field::val_real())[0x5621e500a4d5]

sql/item_cmpfunc.cc:888(Arg_comparator::compare_e_real())[0x5621e507226c]

sql/item_cmpfunc.h:117(Arg_comparator::compare())[0x5621e50b91f8]

sql/item_cmpfunc.cc:1839(Item_func_equal::val_int())[0x5621e507e3ce]

sql/sql_type.cc:5152(Type_handler_int_result::Item_val_bool(Item*) const)[0x5621e4d4058c]

sql/item.h:1513(Item::val_bool())[0x5621e4426316]

sql/item_cmpfunc.cc:5575(Item_cond_and::val_int())[0x5621e50a186d]

sql/opt_range.h:1726(SQL_SELECT::skip_record(THD*))[0x5621e4a4e609]

sql/filesort.cc:940(find_all_keys(THD*, Sort_param*, SQL_SELECT*, SORT_INFO*, st_io_cache*, st_io_cache*, Bounded_queue<unsigned char, unsigned char>*, unsigned long long*))[0x5621e4f7f2d8]

sql/filesort.cc:351(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x5621e4f7a677]

sql/sql_select.cc:24709(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x5621e48802b3]

sql/sql_select.cc:22314(st_join_table::sort_table())[0x5621e486e663]

sql/sql_select.cc:22253(join_init_read_record(st_join_table*))[0x5621e486db46]

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

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

sql/sql_select.cc:4664(JOIN::exec_inner())[0x5621e47ee0b7]

sql/sql_select.cc:4445(JOIN::exec())[0x5621e47eb68a]

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

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

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

sql/sql_parse.cc:4043(mysql_execute_command(THD*))[0x5621e470ea78]

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

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

sql/sql_parse.cc:1375(do_command(THD*))[0x5621e46fcb70]

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

sql/sql_connect.cc:1300(handle_one_connection)[0x5621e4b7023c]

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

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

Query (0x62b0000c42a8): SELECT 1 FROM t1 WHERE v2 +v3 <=> f3 AND v3 < 7 ORDER BY v4

mysqld: /11.8/sql/field.cc:8122: virtual my_decimal* Field_varstring::val_decimal(my_decimal*): Assertion `marked_for_read()' failed.

250117 13:22:07 [ERROR] mysqld got signal 6 ;

Server version: 11.8.0-MariaDB-debug-log source revision: 4119c0185cb0559b9fde397f4892c2ab01fbf8e2

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

sql/field.cc:8123(Field_varstring::val_decimal(my_decimal*))[0x564b863ab527]

sql/item.cc:3469(Item_field::val_decimal(my_decimal*))[0x564b86481b5c]

sql/sql_type.cc:357(VDec::VDec(Item*))[0x564b8616ba86]

sql/item_cmpfunc.cc:950(Arg_comparator::compare_decimal())[0x564b864e9cfb]

sql/item_cmpfunc.h:114(Arg_comparator::compare())[0x564b8652dc42]

sql/item_cmpfunc.cc:1931(Item_func_gt::val_bool())[0x564b864f5728]

sql/item_cmpfunc.cc:5671(Item_cond_and::val_bool())[0x564b86517811]

sql/opt_range.h:1922(SQL_SELECT::skip_record(THD*))[0x564b859377b7]

sql/filesort.cc:1036(find_all_keys(THD*, Sort_param*, SQL_SELECT*, SORT_INFO*, st_io_cache*, st_io_cache*, Bounded_queue*, unsigned long long*))[0x564b863f1427]

sql/filesort.cc:445(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x564b863ec70e]

sql/sql_select.cc:27692(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x564b85bfb0a3]

sql/sql_select.cc:25184(st_join_table::sort_table())[0x564b85be8343]

sql/sql_select.cc:25104(join_init_read_record(st_join_table*))[0x564b85be7725]

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

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

sql/sql_select.cc:5043(JOIN::exec_inner())[0x564b85b57ac9]

sql/sql_select.cc:4826(JOIN::exec())[0x564b85b54e20]

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

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

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

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

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

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

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

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

sql/sql_connect.cc:1329(handle_one_connection)[0x564b85f3414f]

perfschema/pfs.cc:2200(pfs_spawn_thread)[0x564b86c5af06]

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

mysqld: /10.8/sql/field.cc:4597: virtual longlong Field_long::val_int(): Assertion `marked_for_read()' failed.

250116 17:42:47 [ERROR] mysqld got signal 6 ;

Server version: 11.8.0-MariaDB-debug-log source revision: 4119c0185cb0559b9fde397f4892c2ab01fbf8e2

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

sql/field.cc:4600(Field_long::val_int())[0x55beb85d50cf]

sql/item.cc:3461(Item_field::val_int())[0x55beb86d0a17]

sql/item_func.cc:1124(Item_func_plus::int_op())[0x55beb87ca40a]

sql/item_func.cc:842(Item_func_hybrid_field_type::val_decimal_from_int_op(my_decimal*))[0x55beb87c7460]

sql/sql_type.cc:5584(Type_handler_int_result::Item_func_hybrid_field_type_val_decimal(Item_func_hybrid_field_type*, my_decimal*) const)[0x55beb83d9bcb]

sql/item_func.h:993(Item_func_hybrid_field_type::val_decimal(my_decimal*))[0x55beb7c41839]

sql/sql_type.cc:357(VDec::VDec(Item*))[0x55beb83baa86]

sql/item_cmpfunc.cc:950(Arg_comparator::compare_decimal())[0x55beb8738cfb]

sql/item_cmpfunc.h:114(Arg_comparator::compare())[0x55beb877cc42]

sql/item_cmpfunc.cc:1915(Item_func_ne::val_bool())[0x55beb8744556]

sql/item_cmpfunc.cc:5671(Item_cond_and::val_bool())[0x55beb8766811]

sql/opt_range.h:1922(SQL_SELECT::skip_record(THD*))[0x55beb7b867b7]

sql/filesort.cc:1036(find_all_keys(THD*, Sort_param*, SQL_SELECT*, SORT_INFO*, st_io_cache*, st_io_cache*, Bounded_queue*, unsigned long long*))[0x55beb8640427]

sql/filesort.cc:445(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x55beb863b70e]

sql/sql_select.cc:27692(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x55beb7e4a0a3]

sql/sql_select.cc:25184(st_join_table::sort_table())[0x55beb7e37343]

sql/sql_select.cc:25104(join_init_read_record(st_join_table*))[0x55beb7e36725]

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

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

sql/sql_select.cc:5043(JOIN::exec_inner())[0x55beb7da6ac9]

sql/sql_select.cc:4826(JOIN::exec())[0x55beb7da3e20]

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

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

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

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

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

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

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

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

sql/sql_connect.cc:1329(handle_one_connection)[0x55beb818314f]

perfschema/pfs.cc:2200(pfs_spawn_thread)[0x55beb8ea9f06]

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