Corruption-like errors are produced when temporary space limit is reached

--source include/have_sequence.inc

SET MAX_TMP_SESSION_SPACE_USAGE = 1024*1024;

--error 200

SELECT VARIABLE_VALUE FROM information_schema.GLOBAL_VARIABLES JOIN seq_1_to_100

INTERSECT ALL

SELECT VARIABLE_VALUE FROM information_schema.GLOBAL_VARIABLES JOIN seq_1_to_100;

2024-05-13 15:08:29 4 [ERROR] mariadbd: Got error '127 "Table file is corrupted"' for '#sql-temptable-e249a-4-11.MAI'

2024-05-13 15:08:29 4 [ERROR] mariadbd: Table '(temporary)' is marked as crashed and should be repaired

^ Found warnings in /mnt8t/bld/bb-11.5-monty-asan/mysql-test/var/log/mysqld.1.err