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.test3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/subselect3_jcl6.test b/mysql-test/t/subselect3_jcl6.test
index 8d880809476..e4b1c144b93 100644
--- a/mysql-test/t/subselect3_jcl6.test
+++ b/mysql-test/t/subselect3_jcl6.test
@@ -11,9 +11,12 @@ 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 @join_cache_level_for_subselect3_test=@@join_cache_level;
+
--source t/subselect3.test
set join_cache_level=default;
show variables like 'join_cache_level';
set @@optimizer_switch=@save_optimizer_switch;
+set @join_cache_level_for_subselect3_test=NULL;