CREATE TABLE t1 (a INT);

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

CREATE TABLE t2 (b INT);

INSERT INTO t2 VALUES (3),(4);

CREATE TABLE t3 (c INT);

INSERT INTO t3 VALUES (5),(6);

CREATE PROCEDURE sp() CREATE OR REPLACE TEMPORARY TABLE tmp (a INT);

CALL sp;

CALL sp;

CREATE OR REPLACE PROCEDURE sp() UPDATE IGNORE t1, t2 SET t2.b = 0 WHERE t2.b = (SELECT c FROM t3);

CALL sp;

CALL sp;

# Cleanup

DROP PROCEDURE sp;

DROP TABLE t1, t2, t3;

mariadbd: /data/src/11.2/sql/sql_prepare.h:72: bool Reprepare_observer::can_retry() const: Assertion `is_invalidated()' failed.

230807 20:07:54 [ERROR] mysqld got signal 6 ;

#9  0x00007f0e0f653df2 in __GI___assert_fail (assertion=0x562b0a5ca900 "is_invalidated()", file=0x562b0a5ca8a0 "/data/src/11.2/sql/sql_prepare.h", line=72, function=0x562b0a5ca840 "bool Reprepare_observer::can_retry() const") at ./assert/assert.c:101

#10 0x0000562b085cf2df in Reprepare_observer::can_retry (this=0x7f0e07e36830) at /data/src/11.2/sql/sql_prepare.h:72

#11 0x0000562b08bafff6 in sp_lex_keeper::validate_lex_and_exec_core (this=0x6250001a84c8, thd=0x62c0000c0218, nextp=0x7f0e07e36be0, open_tables=false, instr=0x6250001a8490) at /data/src/11.2/sql/sp_instr.cc:498

#12 0x0000562b08bb219e in sp_instr_stmt::execute (this=0x6250001a8490, thd=0x62c0000c0218, nextp=0x7f0e07e36be0) at /data/src/11.2/sql/sp_instr.cc:850

#13 0x0000562b082b17a1 in sp_head::execute (this=0x6250001a19b8, thd=0x62c0000c0218, merge_da_on_success=true) at /data/src/11.2/sql/sp_head.cc:1280

#14 0x0000562b082b7826 in sp_head::execute_procedure (this=0x6250001a19b8, thd=0x62c0000c0218, args=0x62c0000c5678) at /data/src/11.2/sql/sp_head.cc:2267

#15 0x0000562b085133a3 in do_execute_sp (thd=0x62c0000c0218, sp=0x6250001a19b8) at /data/src/11.2/sql/sql_parse.cc:3024

#16 0x0000562b08514f1e in Sql_cmd_call::execute (this=0x6290000e6300, thd=0x62c0000c0218) at /data/src/11.2/sql/sql_parse.cc:3269

#17 0x0000562b0852738e in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/src/11.2/sql/sql_parse.cc:5766

#18 0x0000562b0853422b in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "CALL sp", length=7, parser_state=0x7f0e07e389f0) at /data/src/11.2/sql/sql_parse.cc:7800

#19 0x0000562b0850c77e in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000258219 "CALL sp", packet_length=7, blocking=true) at /data/src/11.2/sql/sql_parse.cc:1892

#20 0x0000562b085094bb in do_command (thd=0x62c0000c0218, blocking=true) at /data/src/11.2/sql/sql_parse.cc:1405

#21 0x0000562b089cc2ae in do_handle_one_connection (connect=0x608000002eb8, put_in_cache=true) at /data/src/11.2/sql/sql_connect.cc:1445

#22 0x0000562b089cbc6f in handle_one_connection (arg=0x608000002e38) at /data/src/11.2/sql/sql_connect.cc:1347

#23 0x0000562b095eac24 in pfs_spawn_thread (arg=0x617000005b98) at /data/src/11.2/storage/perfschema/pfs.cc:2201

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

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