Assertion failure upon using temporary sequence with SBR

--source include/have_binlog_format_statement.inc

CREATE TEMPORARY SEQUENCE s;

SELECT NEXT VALUE FOR s;

mariadbd: /data/bld/main-asan-ubsan/sql/temporary_tables.cc:856: void THD::mark_tmp_table_as_free_for_reuse(TABLE*): Assertion `!mysql_bin_log.is_open()' failed.

250528 14:36:38 [ERROR] /share8t/bld/main-asan-ubsan/sql/mariadbd got signal 6 ;

#10 0x00007fa15e853eb2 in __GI___assert_fail (assertion=0x55560e084020 "!mysql_bin_log.is_open()", file=0x55560e083000 "/data/bld/main-asan-ubsan/sql/temporary_tables.cc", line=856, function=0x55560e083fc0 "void THD::mark_tmp_table_as_free_for_reuse(TABLE*)") at ./assert/assert.c:101

#11 0x000055560b20cf92 in THD::mark_tmp_table_as_free_for_reuse (this=this@entry=0x62c0000d0218, table=table@entry=0x61900006a498) at /data/bld/main-asan-ubsan/sql/temporary_tables.cc:856

#12 0x000055560b213d9e in THD::mark_tmp_tables_as_free_for_reuse (this=this@entry=0x62c0000d0218) at /data/bld/main-asan-ubsan/sql/temporary_tables.cc:810

#13 0x0000555609f4a540 in close_thread_tables (thd=thd@entry=0x62c0000d0218) at /data/bld/main-asan-ubsan/sql/sql_base.cc:946

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

#15 0x000055560a360812 in mysql_execute_command (thd=thd@entry=0x62c0000d0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:5951

#16 0x000055560a363e92 in mysql_parse (thd=thd@entry=0x62c0000d0218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fa14c814a10) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7891

#17 0x000055560a36cecf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0000d0218, packet=packet@entry=0x6290002a3219 "", packet_length=packet_length@entry=23, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1877

#18 0x000055560a379dbb in do_command (thd=thd@entry=0x62c0000d0218, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1416

#19 0x000055560abc1a96 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x60800000c338, put_in_cache=put_in_cache@entry=true) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1414

#20 0x000055560abc2bff in handle_one_connection (arg=0x60800000c338) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1326

#21 0x000055560c6e249b in pfs_spawn_thread (arg=0x617000006618) at /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198

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

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

Commit:     Monty

CommitDate: Mon Apr 28 12:59:38 2025 +0300

    MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable