Assertion `marked_for_read()' in Field_double::val_real / Virtual_column_info::fix_expr

CREATE TABLE t (f DOUBLE NOT NULL, vf DOUBLE AS (RAND(1 AND f)) VIRTUAL);

ALTER TABLE t MODIFY COLUMN IF EXISTS x INT;

INSERT INTO t (f) SELECT f FROM t;

# Cleanup

DROP TABLE t;

mysqld: /data/src/10.4/sql/field.cc:4871: virtual double Field_double::val_real(): Assertion `marked_for_read()' failed.

230327 17:50:24 [ERROR] mysqld got signal 6 ;

#9  0x00007f86e6a53df2 in __GI___assert_fail (assertion=0x56279ae21bc0 "marked_for_read()", file=0x56279ae20f40 "/data/src/10.4/sql/field.cc", line=4871, function=0x56279ae24be0 "virtual double Field_double::val_real()") at ./assert/assert.c:101

#10 0x00005627991a48f7 in Field_double::val_real (this=0x619000084410) at /data/src/10.4/sql/field.cc:4871

#11 0x00005627992831e9 in Item_field::val_real (this=0x6190000848c8) at /data/src/10.4/sql/item.cc:3255

#12 0x00005627992e3c33 in Arg_comparator::compare_real (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.cc:851

#13 0x00005627993263fe in Arg_comparator::compare (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.h:104

#14 0x00005627992ef70c in Item_func_ne::val_int (this=0x61d0001fb8e0) at /data/src/10.4/sql/item_cmpfunc.cc:1809

#15 0x0000562798fea2d0 in Type_handler_int_result::Item_val_bool (this=0x56279bc10240 <type_handler_bool>, item=0x61d0001fb8e0) at /data/src/10.4/sql/sql_type.cc:4607

#16 0x00005627987df9b2 in Item::val_bool (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1473

#17 0x0000562798c1b3de in Item::eval_const_cond (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1481

#18 0x000056279930d889 in Item_cond::fix_fields (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item_cmpfunc.cc:4853

#19 0x00005627987fc81d in Item::fix_fields_if_needed (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item.h:966

#20 0x00005627993692f3 in Item_func::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:355

#21 0x0000562799387769 in Item_func_rand::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:2764

#22 0x0000562798da0deb in Virtual_column_info::fix_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3290

#23 0x0000562798da1254 in Virtual_column_info::fix_session_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3316

#24 0x0000562798da1d80 in TABLE::vcol_fix_expr (this=0x62000003c088, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3402

#25 0x0000562798900910 in open_table (thd=0x62b00005b208, table_list=0x62b000062340, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:2233

#26 0x00005627989091ec in open_and_process_table (thd=0x62b00005b208, tables=0x62b000062340, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0, has_prelocking_list=false, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:3909

#27 0x000056279890bc99 in open_tables (thd=0x62b00005b208, options=..., start=0x7f86dee2fad0, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:4390

#28 0x0000562798910da5 in open_and_lock_tables (thd=0x62b00005b208, options=..., tables=0x62b000062340, derived=true, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:5337

#29 0x000056279886bdd2 in open_and_lock_tables (thd=0x62b00005b208, tables=0x62b000062340, derived=true, flags=0) at /data/src/10.4/sql/sql_base.h:503

#30 0x0000562798a971c1 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4682

#31 0x0000562798aae104 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "INSERT INTO t (f) SELECT f FROM t", length=33, parser_state=0x7f86dee31860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7986

#32 0x0000562798a847c9 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900023f209 "INSERT INTO t (f) SELECT f FROM t", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857

#33 0x0000562798a81351 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378

#34 0x0000562798e76680 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420

#35 0x0000562798e75f97 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324

#36 0x0000562799ac608a in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869

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

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