Tests fail on bb-main-atomic in buildbot and outside

$ perl ./mtr atomic.create_table_binlog --ps

...

atomic.create_table_binlog               [ fail ]

        Test ended at 2026-08-13 21:16:42

CURRENT_TEST: atomic.create_table_binlog

--- /share8t/bld/testing/bb-main-atomic-asan/mysql-test/suite/atomic/create_table_binlog.result	2026-08-08 20:21:54.827451306 +0300

+++ /share8t/bld/testing/bb-main-atomic-asan/mysql-test/suite/atomic/create_table_binlog.reject	2026-08-13 21:16:42.005047251 +0300

@@ -49,12 +49,5 @@

 select count(*) > 0 from t11;

 count(*) > 0

 1

-Warnings:

-Error	145	Table './test/t11' is marked as crashed and should be repaired

-Warning	1034	1 client is using or hasn't closed the table properly

-Warning	1034	Size of datafile is:        42       Should be: 21

-Error	1034	Record-count is not ok; is          6   Should be: 3

-Warning	1034	Found          6 key parts. Should be: 3

-Warning	1034	Number of rows changed from 3 to 6

 drop table t10,t11;

 drop function func_with_sideeffect;

Result length mismatch

$ perl ./mtr main.create_or_replace --view

main.create_or_replace                   [ fail ]

        Test ended at 2026-08-13 21:19:58

CURRENT_TEST: main.create_or_replace

mysqltest: At line 879: query 'SELECT 1' failed: ER_TABLE_NOT_LOCKED (1100): Table 'mysqltest_tmp_v' was not locked with LOCK TABLES

The result from queries just before the failure was:

< snip >

CREATE FUNCTION f(z INT) RETURNS INT READS SQL DATA RETURN (SELECT * FROM t1);

CREATE TABLE t1 (a INT) ENGINE=InnoDB;

CREATE TEMPORARY TABLE t1 (c INT);

CREATE OR REPLACE TABLE t1 AS SELECT f(1);

drop temporary table t1;

drop table t1;

drop function f;

set @@session.drop_before_create_or_replace=default;

#

# End of 10.6 tests

#

#

# MDEV-36497 Assertion failure after atomic CoR with Aria under lock

# in transactional context

#

CREATE TABLE t1 (a INT) engine=aria;

LOCK TABLE t1 WRITE;

SET AUTOCOMMIT = OFF;

CREATE OR REPLACE TABLE t1 (b INT) ENGINE=aria;

SELECT 1;

sql_sequence.create_archive              [ pass ]     12

...

2026-08-13 21:26:37.027698109 +0300

@@ -629,6 +629,7 @@

 def	sys	utf8mb3	utf8mb3_general_ci	NULL	

 def	test	utf8mb4	utf8mb4_uca1400_ai_ci	NULL	

 tables_in_test

+t1

 tables_in_mysql

 mysql.columns_priv

 mysql.column_stats

Result length mismatch

not ok