summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect3_jcl6.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/subselect3_jcl6.test')
-rw-r--r--mysql-test/t/subselect3_jcl6.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/subselect3_jcl6.test b/mysql-test/t/subselect3_jcl6.test
index 9ee23288d99..8d880809476 100644
--- a/mysql-test/t/subselect3_jcl6.test
+++ b/mysql-test/t/subselect3_jcl6.test
@@ -2,6 +2,12 @@
# Run subselect3.test with BKA enabled
#
+set @save_optimizer_switch=@@optimizer_switch;
+set @@optimizer_switch='optimize_join_buffer_size=on';
+set @@optimizer_switch='semijoin_with_cache=on';
+set @@optimizer_switch='outer_join_with_cache=on';
+set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
+
set join_cache_level=6;
show variables like 'join_cache_level';
@@ -9,3 +15,5 @@ show variables like 'join_cache_level';
set join_cache_level=default;
show variables like 'join_cache_level';
+
+set @@optimizer_switch=@save_optimizer_switch;