summaryrefslogtreecommitdiff
path: root/mysql-test/t/join_nested_jcl6.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/join_nested_jcl6.test')
-rw-r--r--mysql-test/t/join_nested_jcl6.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/join_nested_jcl6.test b/mysql-test/t/join_nested_jcl6.test
index 809755b1fbf..0e8646bceda 100644
--- a/mysql-test/t/join_nested_jcl6.test
+++ b/mysql-test/t/join_nested_jcl6.test
@@ -11,6 +11,9 @@ set @@optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on';
set join_cache_level=6;
show variables like 'join_cache_level';
+set @optimizer_switch_for_join_nested_test=@@optimizer_switch;
+set @join_cache_level_for_join_nested_test=@@join_cache_level;
+
--source t/join_nested.test
#
@@ -104,3 +107,5 @@ set join_cache_level=default;
show variables like 'join_cache_level';
set @@optimizer_switch=@save_optimizer_switch_jcl6;
+set @optimizer_switch_for_join_nested_test=NULL;
+set @join_cache_level_for_join_nested_test=NULL;