Assertion `inited == NONE' failed in handler::ha_reset on 2nd execution of trigger

CREATE TABLE t (a INT);

INSERT INTO t VALUES (1),(2);

CREATE TRIGGER tr AFTER DELETE ON t FOR EACH ROW CREATE TEMPORARY TABLE tmp AS SELECT 1 FROM t WHERE SUBTIME('2000-01-01', '00:00:00') IS NULL AND TRUE;

--error ER_TRUNCATED_WRONG_VALUE

DELETE FROM t;

--error ER_TRUNCATED_WRONG_VALUE

DELETE FROM t;

DROP TABLE t;

mariadbd: /data/bld/11.8-asan-ubsan/sql/handler.cc:7783: int handler::ha_reset(): Assertion `inited == NONE' failed.

250716  0:18:57 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007f70b8e53eb2 in __GI___assert_fail (assertion=0x55b235171fa0 "inited == NONE", file=0x55b23516b9a0 "/data/bld/11.8-asan-ubsan/sql/handler.cc", line=7783, function=0x55b235175940 "int handler::ha_reset()") at ./assert/assert.c:101

#11 0x000055b2326f9430 in handler::ha_reset (this=this@entry=0x625000250948) at /data/bld/11.8-asan-ubsan/sql/handler.cc:7783

#12 0x000055b230f08c84 in mark_used_tables_as_free_for_reuse (thd=thd@entry=0x62c0000b0218, table=0x61900005b498) at /data/bld/11.8-asan-ubsan/sql/sql_base.cc:704

#13 0x000055b230f175d5 in close_thread_tables (thd=thd@entry=0x62c0000b0218) at /data/bld/11.8-asan-ubsan/sql/sql_base.cc:952

#14 0x000055b230f17e48 in close_thread_tables_for_query (thd=thd@entry=0x62c0000b0218) at /data/bld/11.8-asan-ubsan/sql/sql_base.cc:819

#15 0x000055b2312efa5b in mysql_execute_command (thd=0x62c0000b0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:5976

#16 0x000055b231f28f4a in sp_instr_stmt::exec_core (this=0x6250002594e8, thd=<optimized out>, nextp=0x7f70acf48710) at /data/bld/11.8-asan-ubsan/sql/sp_instr.cc:1099

#17 0x000055b231f3e1cb in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x625000259520, thd=thd@entry=0x62c0000b0218, nextp=nextp@entry=0x7f70acf48710, open_tables=open_tables@entry=false, instr=instr@entry=0x6250002594e8, rerun_the_same_instr=rerun_the_same_instr@entry=true) at /data/bld/11.8-asan-ubsan/sql/sp_instr.cc:314

#18 0x000055b231f456ae in sp_lex_keeper::validate_lex_and_exec_core (this=this@entry=0x625000259520, thd=thd@entry=0x62c0000b0218, nextp=nextp@entry=0x7f70acf48710, open_tables=open_tables@entry=false, instr=instr@entry=0x6250002594e8) at /data/bld/11.8-asan-ubsan/sql/sp_instr.cc:493

#19 0x000055b231f47b76 in sp_instr_stmt::execute (this=0x6250002594e8, thd=0x62c0000b0218, nextp=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/sp_instr.cc:1001

#20 0x000055b230de6dd0 in sp_head::execute (this=this@entry=0x625000253138, thd=thd@entry=0x62c0000b0218, merge_da_on_success=merge_da_on_success@entry=false) at /data/bld/11.8-asan-ubsan/sql/sp_head.cc:1291

#21 0x000055b230decb34 in sp_head::execute_trigger (this=this@entry=0x625000253138, thd=thd@entry=0x62c0000b0218, db_name=db_name@entry=0x62500024e520, table_name=table_name@entry=0x62500024e530, grant_info=grant_info@entry=0x625000251ad8) at /data/bld/11.8-asan-ubsan/sql/sp_head.cc:1801

#22 0x000055b23187923a in Table_triggers_list::process_triggers (this=this@entry=0x6250002514c8, thd=thd@entry=0x62c0000b0218, event=event@entry=TRG_EVENT_DELETE, time_type=time_type@entry=TRG_ACTION_AFTER, old_row_is_record1=old_row_is_record1@entry=false, skip_row_indicator=skip_row_indicator@entry=0x0, fields_in_update_stmt=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/sql_trigger.cc:2728

#23 0x000055b2310a1277 in Sql_cmd_delete::delete_from_single_table (this=this@entry=0x62d0000f13b8, thd=thd@entry=0x62c0000b0218) at /data/bld/11.8-asan-ubsan/sql/sql_delete.cc:914

#24 0x000055b2310a86e5 in Sql_cmd_delete::execute_inner (this=0x62d0000f13b8, thd=0x62c0000b0218) at /data/bld/11.8-asan-ubsan/sql/sql_delete.cc:2083

#25 0x000055b231468604 in Sql_cmd_dml::execute (this=0x62d0000f13b8, thd=0x62c0000b0218) at /data/bld/11.8-asan-ubsan/sql/sql_select.cc:34499

#26 0x000055b2312d91fe in mysql_execute_command (thd=thd@entry=0x62c0000b0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:4428

#27 0x000055b2312f3083 in mysql_parse (thd=thd@entry=0x62c0000b0218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f70acf4aa20) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:7906

#28 0x000055b2312fc399 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0000b0218, packet=packet@entry=0x629000253219 "DELETE FROM t", packet_length=packet_length@entry=13, blocking=blocking@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_parse.cc:1902

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

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

#31 0x000055b231b4c363 in handle_one_connection (arg=0x6080000039b8) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327

#32 0x000055b2335dec2e in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198

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

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

commit 0e21ff8ca47ab637564b4c120322215caa70835d

Author: Sergei Petrunia

Date:   Mon Jan 20 17:44:51 2025 +0200

    MDEV-35318 Assertion `tl->jtbm_subselect' failed in JOIN::calc_allowed_top_level_tables

    Alternative, more general fix, Variant 2.