spider failures in mismatch select argument results in s390x / ppc64le / asan / valgrind builders

spider/feature.checksum_table_parallel_extended w29 [ fail ]

        Test ended at 2024-09-30 08:15:29

CURRENT_TEST: spider/feature.checksum_table_parallel_extended

--- /home/buildbot/amd64-fedora-40-valgrind/build/storage/spider/mysql-test/spider/feature/r/checksum_table_parallel_extended.result	2024-09-30 07:49:13.000000000 +0000

+++ /home/buildbot/amd64-fedora-40-valgrind/build/storage/spider/mysql-test/spider/feature/r/checksum_table_parallel_extended.reject	2024-09-30 08:15:27.200950736 +0000

@@ -70,7 +70,6 @@

 connection child2_2_2;

 SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%checksum %';

 argument

-checksum table `auto_test_remote2`.`tbl_a` extended

 SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%checksum %'

 connection child2_1;

 UNLOCK TABLES;

spider.partition_mrr                     w2 [ fail ]

        Test ended at 2024-09-30 08:25:04

CURRENT_TEST: spider.partition_mrr

--- /home/buildbot/amd64-fedora-40-valgrind/build/storage/spider/mysql-test/spider/r/partition_mrr.result	2024-09-30 07:49:13.000000000 +0000

+++ /home/buildbot/amd64-fedora-40-valgrind/build/storage/spider/mysql-test/spider/r/partition_mrr.reject	2024-09-30 08:25:02.791096042 +0000

@@ -163,10 +163,10 @@

 select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`

-select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote`.`tbl_b` order by `pkey`

+select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote`.`tbl_a` order by `pkey`

 SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'

 SELECT pkey FROM tbl_a ORDER BY pkey ;

 SELECT pkey FROM tbl_b ORDER BY pkey;

@@ -199,10 +199,10 @@

 select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`

-select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote2`.`tbl_b` order by `pkey`

+select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote2`.`tbl_a` order by `pkey`

 SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'

 SELECT pkey FROM tbl_a ORDER BY pkey ;

 SELECT pkey FROM tbl_b ORDER BY pkey;

@@ -235,10 +235,10 @@

 select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`

-select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

-select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

 select `pkey` from `auto_test_remote3`.`tbl_b` order by `pkey`

+select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`

+select `pkey` from `auto_test_remote3`.`tbl_a` order by `pkey`

 SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%select %'

 SELECT pkey FROM tbl_a ORDER BY pkey ;

 SELECT pkey FROM tbl_b ORDER BY pkey;