summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_sj2_mat.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/subselect_sj2_mat.test')
-rw-r--r--mysql-test/t/subselect_sj2_mat.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj2_mat.test b/mysql-test/t/subselect_sj2_mat.test
index f54771856e7..1b15e88bdcc 100644
--- a/mysql-test/t/subselect_sj2_mat.test
+++ b/mysql-test/t/subselect_sj2_mat.test
@@ -1,6 +1,8 @@
#
# Run subselect_sj2.test with subquery materialization.
#
+--source include/default_optimizer_switch.inc
+
set optimizer_switch='materialization=on';
set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';