Assertion `marked_for_read()' failed in virtual my_time_t Field_timestamp0::get_timestamp(const uchar*, ulong*) const

SET GLOBAL mysql56_temporal_format=0;

SET explicit_defaults_for_timestamp=0;

CREATE TABLE t (b TIMESTAMP,a INT AS (1 IN (DAYOFMONTH (b between''AND current_user)=b)));

--error ER_NO_SUCH_TABLE

SELECT * FROM t,t2;

SELECT * FROM t;

mariadbd: /test/11.7_dbg/sql/field.cc:5291: virtual my_time_t Field_timestamp0::get_timestamp(const uchar*, ulong*) const: Assertion `marked_for_read()' failed.

Core was generated by `/test/MD090924-mariadb-11.7.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGABRT, Aborted.

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

[Current thread is 1 (Thread 0x147200060700 (LWP 2122510))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x0000147201fe9859 in __GI_abort () at abort.c:79

#2  0x0000147201fe9729 in __assert_fail_base (fmt=0x14720217f588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56185fabc2bd "marked_for_read()", file=0x56185fabc12b "/test/11.7_dbg/sql/field.cc", line=5291, function=<optimized out>) at assert.c:92

#3  0x0000147201ffafd6 in __GI___assert_fail (assertion=assertion@entry=0x56185fabc2bd "marked_for_read()", file=file@entry=0x56185fabc12b "/test/11.7_dbg/sql/field.cc", line=line@entry=5291, function=function@entry=0x56185fabd8c0 "virtual my_time_t Field_timestamp0::get_timestamp(const uchar*, ulong*) const") at assert.c:101

#4  0x000056185eece5f3 in Field_timestamp0::get_timestamp (this=0x1471bc02df50, pos=0x1471bc02df09 "", sec_part=0x14720005d2b8) at /test/11.7_dbg/sql/field.cc:5291

#5  0x000056185eec7697 in Field::get_timestamp (sec_part=0x14720005d2b8, this=0x1471bc02df50) at /test/11.7_dbg/sql/field.h:1248

#6  Field_timestamp::get_date (this=0x1471bc02df50, ltime=0x14720005d310, fuzzydate={m_mode = (date_mode_t::FUZZY_DATES | date_mode_t::FRAC_TRUNCATE | date_mode_t::INVALID_DATES)}) at /test/11.7_dbg/sql/field.cc:5576

#7  0x000056185ef1f2b3 in Item_field::get_date_result (this=this@entry=0x1471bc02e320, thd=thd@entry=0x1471bc000d48, ltime=ltime@entry=0x14720005d310, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/field.h:1428

#8  0x000056185ef26c68 in Item::val_datetime_packed_result (this=this@entry=0x1471bc02e320, thd=0x1471bc000d48) at /test/11.7_dbg/sql/sql_basic_types.h:81

#9  0x000056185ef26d73 in Item_cache_temporal::cache_value (this=0x1471bc024450) at /test/11.7_dbg/sql/item.cc:10457

#10 0x000056185ef3ddc8 in Item_cache::has_value (this=0x1471bc024450) at /test/11.7_dbg/sql/item.h:7605

#11 Item_cache_datetime::val_datetime_packed (this=0x1471bc024450) at /test/11.7_dbg/sql/item.h:7605

#12 0x000056185ef6024f in Item_func_between::val_int_cmp_datetime (this=0x1471bc02e570) at /test/11.7_dbg/sql/item_cmpfunc.cc:2312

#13 0x000056185ee0f8e0 in Type_handler_temporal_with_date::Item_func_between_val_int (this=<optimized out>, func=<optimized out>) at /test/11.7_dbg/sql/sql_type.cc:5863

#14 0x000056185eaaa7dd in Item_func_between::val_int (this=0x1471bc02e570) at /test/11.7_dbg/sql/sql_type.h:7748

#15 0x000056185ef2ba33 in Item::get_date_from_int (this=0x1471bc02e570, thd=0x1471bc000d48, ltime=0x14720005d540, fuzzydate={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/11.7_dbg/sql/item.cc:1465

#16 0x000056185eaab141 in Item_int_func::get_date (this=<optimized out>, thd=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/item_func.h:1249

#17 0x000056185ee244e5 in Temporal_with_date::make_from_item (this=this@entry=0x14720005d540, thd=0x1471bc000d48, item=0x1471bc02e570, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/sql_type.cc:1090

#18 0x000056185ee31f81 in Temporal_with_date::Temporal_with_date (fuzzydate=<optimized out>, item=<optimized out>, thd=<optimized out>, this=0x14720005d540) at /test/11.7_dbg/sql/sql_type.h:2156

#19 Datetime::Datetime (this=0x14720005d540, thd=<optimized out>, item=<optimized out>, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/sql_type.h:2435

#20 0x000056185f050f37 in Item_func_dayofmonth::val_int (this=0x1471bc023328) at /test/11.7_dbg/sql/sql_basic_types.h:81

#21 0x000056185ef2ba33 in Item::get_date_from_int (this=0x1471bc023328, thd=0x1471bc000d48, ltime=0x14720005d700, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/11.7_dbg/sql/item.cc:1465

#22 0x000056185eaab141 in Item_int_func::get_date (this=<optimized out>, thd=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/item_func.h:1249

#23 0x000056185ee244e5 in Temporal_with_date::make_from_item (this=this@entry=0x14720005d700, thd=0x1471bc000d48, item=0x1471bc023328, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/sql_type.cc:1090

#24 0x000056185ee31f81 in Temporal_with_date::Temporal_with_date (fuzzydate=<optimized out>, item=<optimized out>, thd=<optimized out>, this=0x14720005d700) at /test/11.7_dbg/sql/sql_type.h:2156

#25 Datetime::Datetime (this=0x14720005d700, thd=<optimized out>, item=<optimized out>, fuzzydate=<optimized out>) at /test/11.7_dbg/sql/sql_type.h:2435

#26 0x000056185ee24676 in Type_handler_datetime_common::convert_item_for_comparison (this=<optimized out>, thd=0x1471bc000d48, subject=0x1471bc023328, counterpart=<optimized out>) at /test/11.7_dbg/sql/sql_basic_types.h:281

#27 0x000056185ef5cb0b in Item_func::aggregate_args2_for_comparison_with_conversion (this=this@entry=0x1471bc0234f8, thd=thd@entry=0x1471bc000d48, th=th@entry=0x14720005d7d8) at /test/11.7_dbg/sql/sql_type.h:7748

#28 0x000056185ef5cdd5 in Item_bool_rowready_func2::fix_length_and_dec (this=0x1471bc0234f8, thd=0x1471bc000d48) at /test/11.7_dbg/sql/item_cmpfunc.cc:530

#29 0x000056185ef95531 in Item_func::fix_fields (this=0x1471bc0234f8, thd=0x1471bc000d48, ref=<optimized out>) at /test/11.7_dbg/sql/item_func.cc:370

#30 0x000056185ef954fd in Item::fix_fields_if_needed (ref=0x1471bc0237b0, thd=0x1471bc000d48, this=<optimized out>) at /test/11.7_dbg/sql/item.h:1167

#31 Item_func::fix_fields (this=0x1471bc023728, thd=0x1471bc000d48, ref=<optimized out>) at /test/11.7_dbg/sql/item_func.cc:352

#32 0x000056185ecf8e11 in Virtual_column_info::fix_expr (this=this@entry=0x1471bc02e6c8, thd=thd@entry=0x1471bc000d48) at /test/11.7_dbg/sql/table.cc:3758

#33 0x000056185ecf8f8a in Virtual_column_info::fix_session_expr (this=0x1471bc02e6c8, thd=thd@entry=0x1471bc000d48) at /test/11.7_dbg/sql/table.cc:3784

#34 0x000056185ecf92c4 in TABLE::vcol_fix_expr (this=<optimized out>, thd=thd@entry=0x1471bc000d48) at /test/11.7_dbg/sql/table.cc:3868

#35 0x000056185eb2612f in open_table (thd=thd@entry=0x1471bc000d48, table_list=table_list@entry=0x1471bc01b0f0, ot_ctx=ot_ctx@entry=0x14720005e650) at /test/11.7_dbg/sql/sql_base.cc:2378

#36 0x000056185eb2b280 in open_and_process_table (ot_ctx=0x14720005e650, has_prelocking_list=false, prelocking_strategy=0x14720005e740, flags=0, counter=0x14720005e6ec, tables=0x1471bc01b0f0, thd=0x1471bc000d48) at /test/11.7_dbg/sql/sql_base.cc:4174

#37 open_tables (thd=thd@entry=0x1471bc000d48, options=@0x1471bc0067d0: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x14720005e6d8, counter=counter@entry=0x14720005e6ec, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x14720005e740) at /test/11.7_dbg/sql/sql_base.cc:4660

#38 0x000056185eb2c2d8 in open_and_lock_tables (thd=thd@entry=0x1471bc000d48, options=<optimized out>, tables=<optimized out>, tables@entry=0x1471bc01b0f0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x14720005e740) at /test/11.7_dbg/sql/sql_base.cc:5634

#39 0x000056185ebb003d in open_and_lock_tables (flags=0, derived=true, tables=0x1471bc01b0f0, thd=0x1471bc000d48) at /test/11.7_dbg/sql/sql_base.h:532

#40 execute_sqlcom_select (thd=thd@entry=0x1471bc000d48, all_tables=0x1471bc01b0f0) at /test/11.7_dbg/sql/sql_parse.cc:6075

#41 0x000056185ebb8b9c in mysql_execute_command (thd=thd@entry=0x1471bc000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.7_dbg/sql/sql_parse.cc:3954

#42 0x000056185eba9652 in mysql_parse (thd=thd@entry=0x1471bc000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14720005f270) at /test/11.7_dbg/sql/sql_parse.cc:7876

#43 0x000056185ebc0ad1 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1471bc000d48, packet=packet@entry=0x1471bc00b249 "SELECT * FROM t", packet_length=packet_length@entry=15, blocking=blocking@entry=true) at /test/11.7_dbg/sql/sql_class.h:1639

#44 0x000056185ebc35d4 in do_command (thd=0x1471bc000d48, blocking=blocking@entry=true) at /test/11.7_dbg/sql/sql_parse.cc:1405

#45 0x000056185ed4d067 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56186285bab8, put_in_cache=put_in_cache@entry=true) at /test/11.7_dbg/sql/sql_connect.cc:1448

#46 0x000056185ed4d628 in handle_one_connection (arg=arg@entry=0x56186285bab8) at /test/11.7_dbg/sql/sql_connect.cc:1350

#47 0x000056185f1db0fe in pfs_spawn_thread (arg=0x5618628bf1a8) at /test/11.7_dbg/storage/perfschema/pfs.cc:2198

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

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