diff --git a/storage/spider/mysql-test/spider/bg/t/basic_sql.test b/storage/spider/mysql-test/spider/bg/t/basic_sql.test

index 9cf4ce99dc3..6a35fe8dd70 100644

--- a/storage/spider/mysql-test/spider/bg/t/basic_sql.test

+++ b/storage/spider/mysql-test/spider/bg/t/basic_sql.test

@@ -156,6 +156,7 @@ if ($USE_CHILD_GROUP2)

   }

 }

 --connection master_1

+set @@optimizer_switch="semijoin=off";

 SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;

 --echo

+++ /home/my/maria-10.11/storage/spider/mysql-test/spider/bg/r/basic_sql.reject2023-01-13 20:10:47.205034143 +0200

@@ -49,6 +49,7 @@

 ) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1

 SELECT a, b, c FROM tb_l

 connection master_1;

+set @@optimizer_switch="semijoin=off";

 SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;

 a      b       date_format(c, '%Y-%m-%d %H:%i:%s')

 1      a       2008-08-01 10:21:39

@@ -279,11 +280,6 @@

 SELECT a.a, a.b, date_format(a.c, '%Y-%m-%d %H:%i:%s') FROM tb_l a WHERE

 EXISTS (SELECT * FROM ta_l b WHERE b.b = a.b) ORDER BY a.a;

 a      b       date_format(a.c, '%Y-%m-%d %H:%i:%s')

-1      f       2008-07-01 10:21:39

-2      g       2000-02-01 00:00:00

-3      j       2007-05-04 20:03:11

-4      i       2003-10-30 05:01:03

-5      h       2001-10-31 23:59:59