binlog.global_temporary_table/rpl.global_temporary_table fails to set max_session_mem_used

binlog.global_temporary_table 'stmt'     w10 [ fail ]

        Test ended at 2026-07-16 07:29:31

CURRENT_TEST: binlog.global_temporary_table

mysqltest: In included file "./main/global_temporary_table.test": 

included from /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/suite/binlog/t/global_temporary_table.test at line 7:

At line 1124: query 'set max_session_mem_used= default' failed: ER_OPTION_PREVENTS_STATEMENT (1290): The MariaDB server is running with the --max-session-mem-used=8192 option so it cannot execute this statement

The result from queries just before the failure was:

< snip >

create global temporary table t (c int);

lock tables t read;

create temporary table t1 like t;

ERROR HY000: Failed to open t.test

begin;

commit;

drop table t;

set pseudo_slave_mode=0;

Warnings:

Warning	1231	Slave applier execution mode not active, statement ineffective.

# MDEV-38480 GTT: Aria gets error HA_ERR_CRASHED_ON_USAGE after TRUNCATE

set autocommit=0;

create global temporary table t (c int) engine=aria;

lock tables t write;

select * from t;

c

set max_session_mem_used=8192;

truncate t;

ERROR HY000: The MariaDB server is running with the --max-session-mem-used=8192 option so it cannot execute this statement

set max_session_mem_used= default;

More results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/10/log/global_temporary_table.log

Warnings from just before the error:

Error 1290 The MariaDB server is running with the --max-session-mem-used=8192 option so it cannot execute this statement

 - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/10/log/binlog.global_temporary_table-stmt/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/binlog.global_temporary_table-stmt/'