Assertion failures after failed DML on table with app period and vector key

--source include/have_innodb.inc

CREATE TABLE t (s DATE, e DATE, v VECTOR(1) NOT NULL, VECTOR(v), PERIOD FOR p(s,e)) ENGINE=InnoDB;

--error ER_PERIOD_COLUMNS_UPDATED

UPDATE t FOR PORTION OF p FROM '2000-01-01' TO '2001-01-01' SET e = '2020-01-01';

--connect (con1,localhost,root,,)

INSERT INTO t VALUES ('2025-01-01','2026-01-01',0x31313131);

DROP TABLE t;

mariadbd: /data/bld/11.8-asan-ubsan/sql/handler.cc:3531: THD* handler::ha_thd() const: Assertion `!table || !table->in_use || table->in_use == _current_thd()' failed.

250512 21:46:03 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007f2f8a853eb2 in __GI___assert_fail (assertion=0x5614cb560da0 "!table || !table->in_use || table->in_use == _current_thd()", file=0x5614cb55ac20 "/data/bld/11.8-asan-ubsan/sql/handler.cc", line=3531, function=0x5614cb560d60 "THD* handler::ha_thd() const") at ./assert/assert.c:101

#11 0x00005614c8ac1aeb in handler::ha_thd (this=this@entry=0x625000294148) at /data/bld/11.8-asan-ubsan/sql/handler.cc:3531

#12 0x00005614c9da1a34 in ha_innobase::table_flags (this=this@entry=0x625000294148) at /data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc:4995

#13 0x00005614c9e23a2d in ha_innobase::external_lock (this=0x625000294148, thd=<optimized out>, lock_type=<optimized out>) at /data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc:16143

#14 0x00005614c8b0398b in handler::ha_external_lock (this=this@entry=0x625000294148, thd=<optimized out>, lock_type=lock_type@entry=1) at /data/bld/11.8-asan-ubsan/sql/handler.cc:7694

#15 0x00005614c7343c18 in TABLE::hlindex_lock (this=this@entry=0x61900007df98, nr=nr@entry=0) at /data/bld/11.8-asan-ubsan/sql/sql_base.cc:9917

#16 0x00005614c7344b48 in TABLE::open_hlindexes_for_write (this=this@entry=0x61900007df98) at /data/bld/11.8-asan-ubsan/sql/sql_base.cc:9938

#17 0x00005614c8b0940c in handler::prepare_for_modify (this=this@entry=0x62500028f148, can_set_fields=can_set_fields@entry=true, can_lookup=can_lookup@entry=false) at /data/bld/11.8-asan-ubsan/sql/handler.cc:8162

#18 0x00005614c75563e3 in mysql_insert (thd=thd@entry=0x62c000220218, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/sql_insert.cc:972

#19 0x00005614c76eb52e in mysql_execute_command (thd=thd@entry=0x62c000220218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:4484

#20 0x00005614c7703c79 in mysql_parse (thd=thd@entry=0x62c000220218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f2f72a6fa20) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7915

#21 0x00005614c770cf8f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c000220218, packet=packet@entry=0x6290002ee219 "INSERT INTO t VALUES ('2025-01-01','2026-01-01',0x31313131)", packet_length=packet_length@entry=59, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1902

#22 0x00005614c7719e9d in do_command (thd=thd@entry=0x62c000220218, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1415

#23 0x00005614c7f5a590 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6080000090b8, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1415

#24 0x00005614c7f5b6f9 in handle_one_connection (arg=0x6080000090b8) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327

#25 0x00005614c99f6a7a in pfs_spawn_thread (arg=0x617000008598) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198

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

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

--source include/have_innodb.inc

CREATE TABLE t (s DATE, e DATE, v VECTOR(1) NOT NULL, VECTOR(v), PERIOD FOR p(s,e)) ENGINE=InnoDB;

--error ER_PERIOD_COLUMNS_UPDATED

UPDATE t FOR PORTION OF p FROM '2000-01-01' TO '2001-01-01' SET e = '2020-01-01';

DROP TABLE t;

mariadbd: /data/bld/11.8-asan-ubsan/sql/handler.cc:3718: int handler::ha_close(): Assertion `m_lock_type == 2' failed.

250512 21:47:31 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007f03acc53eb2 in __GI___assert_fail (assertion=0x55c70a01c120 "m_lock_type == 2", file=0x55c70a015c20 "/data/bld/11.8-asan-ubsan/sql/handler.cc", line=3718, function=0x55c70a01c0a0 "int handler::ha_close()") at ./assert/assert.c:101

#11 0x000055c70757e70c in handler::ha_close (this=this@entry=0x625000294148) at /data/bld/11.8-asan-ubsan/sql/handler.cc:3718

#12 0x000055c706845042 in closefrm (table=0x625000290b08) at /data/bld/11.8-asan-ubsan/sql/table.cc:4851

#13 0x000055c706844f24 in closefrm (table=table@entry=0x61900007df98) at /data/bld/11.8-asan-ubsan/sql/table.cc:4848

#14 0x000055c70704c18c in intern_close_table (table=0x61900007df98) at /data/bld/11.8-asan-ubsan/sql/table_cache.cc:230

#15 0x000055c70704e5d1 in TDC_element::flush_unused (this=this@entry=0x61a00005beb8, mark_flushed=mark_flushed@entry=true) at /data/bld/11.8-asan-ubsan/sql/table_cache.cc:1318

#16 0x000055c70704e71a in tdc_remove_referenced_share (thd=thd@entry=0x62c0001e0218, share=0x62500028c938) at /data/bld/11.8-asan-ubsan/sql/table_cache.cc:1028

#17 0x000055c707051188 in tdc_remove_table (thd=thd@entry=0x62c0001e0218, db=<optimized out>, table_name=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/table_cache.cc:1086

#18 0x000055c70667e440 in mysql_rm_table_no_locks (thd=thd@entry=0x62c0001e0218, tables=tables@entry=0x62d0003ca520, current_db=current_db@entry=0x62c0001e02b8, ddl_log_state=0x7f0397a05a90, ddl_log_state@entry=0x0, if_exists=if_exists@entry=false, drop_temporary=drop_temporary@entry=false, drop_view=<optimized out>, drop_sequence=<optimized out>, dont_log_query=<optimized out>, dont_free_locks=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/sql_table.cc:1646

#19 0x000055c7066830af in mysql_rm_table (thd=thd@entry=0x62c0001e0218, tables=tables@entry=0x62d0003ca520, if_exists=<optimized out>, drop_temporary=drop_temporary@entry=false, drop_sequence=drop_sequence@entry=false, dont_log_query=dont_log_query@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_table.cc:1211

#20 0x000055c7061abe43 in mysql_execute_command (thd=thd@entry=0x62c0001e0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:4797

#21 0x000055c7061bec79 in mysql_parse (thd=thd@entry=0x62c0001e0218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f0397a07a20) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7915

#22 0x000055c7061c7f8f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0001e0218, packet=packet@entry=0x629000280219 "DROP TABLE t", packet_length=packet_length@entry=12, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1902

#23 0x000055c7061d4e9d in do_command (thd=thd@entry=0x62c0001e0218, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1415

#24 0x000055c706a15590 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000008fb8, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1415

#25 0x000055c706a166f9 in handle_one_connection (arg=0x608000008fb8) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327

#26 0x000055c7084b1a7a in pfs_spawn_thread (arg=0x617000008218) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198

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

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

--source include/have_innodb.inc

CREATE TABLE t (s DATE, e DATE, v VECTOR(1) NOT NULL, VECTOR(v), PERIOD FOR p(s,e)) ENGINE=InnoDB;

--error ER_PERIOD_COLUMNS_UPDATED

UPDATE t FOR PORTION OF p FROM '2000-01-01' TO '2001-01-01' SET e = '2020-01-01';

--source include/restart_mysqld.inc

DROP TABLE t;

2025-05-12 21:48:54 0 [Note] /share8t/bld/11.8-asan-ubsan/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown

mariadbd: /data/bld/11.8-asan-ubsan/storage/innobase/trx/trx0trx.cc:379: void trx_t::free(): Assertion `!n_mysql_tables_in_use' failed.

250512 21:48:54 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007fcd6fe53eb2 in __GI___assert_fail (assertion=0x55ffa752ddc0 "!n_mysql_tables_in_use", file=0x55ffa752f160 "/data/bld/11.8-asan-ubsan/storage/innobase/trx/trx0trx.cc", line=379, function=0x55ffa752de00 "void trx_t::free()") at ./assert/assert.c:101

#11 0x000055ffa616dd23 in trx_t::free (this=this@entry=0x7fcd61d0a3c0) at /data/bld/11.8-asan-ubsan/storage/innobase/trx/trx0trx.cc:379

#12 0x000055ffa59ca629 in innobase_close_connection (thd=0x62c0001e0218) at /data/bld/11.8-asan-ubsan/storage/innobase/handler/ha_innodb.cc:2931

#13 0x000055ffa46811d4 in ha_close_connection (thd=thd@entry=0x62c0001e0218) at /data/bld/11.8-asan-ubsan/sql/handler.cc:969

#14 0x000055ffa2fe5b16 in THD::free_connection (this=this@entry=0x62c0001e0218) at /data/bld/11.8-asan-ubsan/sql/sql_class.cc:1748

#15 0x000055ffa2b30a57 in unlink_thd (thd=thd@entry=0x62c0001e0218) at /data/bld/11.8-asan-ubsan/sql/mysqld.cc:2880

#16 0x000055ffa3b27be6 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000008fb8, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1426

#17 0x000055ffa3b286f9 in handle_one_connection (arg=0x608000008fb8) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327

#18 0x000055ffa55c3a7a in pfs_spawn_thread (arg=0x617000008218) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198

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