summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_no_mat.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/subselect_no_mat.test')
-rw-r--r--mysql-test/t/subselect_no_mat.test1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_no_mat.test b/mysql-test/t/subselect_no_mat.test
index 5fbbef5caed..0265ec91e88 100644
--- a/mysql-test/t/subselect_no_mat.test
+++ b/mysql-test/t/subselect_no_mat.test
@@ -3,6 +3,7 @@
#
select @@optimizer_switch like '%materialization=on%';
set optimizer_switch='materialization=off';
+set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
--source t/subselect.test