main.join_cache_notasan 'innodb' fails by passing instead of failing on ER_OUTOFMEMORY on armhf and hppa

main.join_cache_notasan 'innodb'         w2 [ fail ]

        Test ended at 2024-04-15 00:49:43

CURRENT_TEST: main.join_cache_notasan

mysqltest: At line 30: query 'SELECT t1.i,t2.i FROM t2  LEFT  JOIN t1 ON t1.i = t2.i  WHERE t1.i' succeeded - should have failed with error ER_OUTOFMEMORY (1037)...

The result from queries just before the failure was:

#

# MDEV-28217 Incorrect Join Execution When Controlling Join Buffer Size

#

CREATE TABLE t1 (i int PRIMARY KEY)engine=innodb;

INSERT INTO t1 VALUES (1332945389);

CREATE TABLE t2 (i int PRIMARY KEY)engine=innodb;

INSERT INTO t2 VALUES (1180244875), (1951338178);

SET SESSION join_buffer_size= X;

Warnings:

Warning	X	Truncated incorrect join_buffer_size value: 'X'

SET SESSION join_cache_level = 4;

SET optimizer_switch='optimize_join_buffer_size=on';

SELECT t2.i FROM t2  LEFT  JOIN t1 ON t1.i = t2.i  WHERE t1.i;

i

SET optimizer_switch='optimize_join_buffer_size=off';

SELECT t1.i,t2.i FROM t2  LEFT  JOIN t1 ON t1.i = t2.i  WHERE t1.i;

 - skipping '/build/reproducible-path/mariadb-10.11.7/builddir/mysql-test/var/2/log/main.join_cache_notasan-innodb/'

Retrying test main.join_cache_notasan, attempt(2/3)...