summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_no_semijoin.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/subselect_no_semijoin.test')
-rw-r--r--mysql-test/t/subselect_no_semijoin.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/subselect_no_semijoin.test b/mysql-test/t/subselect_no_semijoin.test
index e9f2e0654ce..c836c12ec50 100644
--- a/mysql-test/t/subselect_no_semijoin.test
+++ b/mysql-test/t/subselect_no_semijoin.test
@@ -1,8 +1,8 @@
#
# Run subselect.test without semi-join optimization (test materialize)
#
-set optimizer_switch='semijoin=off';
+set @optimizer_switch_for_subselect_test='semijoin=off,mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
--source t/subselect.test
-set optimizer_switch=default;
+set @optimizer_switch_for_subselect_test=null;