Change the default @@optimizer_switch settings:

- semijoin=on
- firstmatch=on
- loosescan=on

1 files changed, 5 insertions, 0 deletions

diff --git a/mysql-test/t/subselect_nulls.test b/mysql-test/t/subselect_nulls.test
index 6de7820872c..4b08e773b17 100644
--- a/mysql-test/t/subselect_nulls.test
+++ b/mysql-test/t/subselect_nulls.test
@@ -5,6 +5,9 @@ drop table if exists x1;
 drop table if exists x2;
 --enable_warnings
 
+set @tmp_subselect_nulls=@@optimizer_switch;
+set optimizer_switch='semijoin=off';
+
 create table x1(k int primary key, d1 int, d2 int);
 create table x2(k int primary key, d1 int, d2 int);
 
@@ -90,5 +93,7 @@ where exists (select *
               from x2
               where x1.d1=x2.d1 and x1.d2=x2.d2);
 
+set optimizer_switch= @tmp_subselect_nulls;
+
 drop table x1;
 drop table x2;