summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_mat.test
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2011-07-05 01:44:15 +0400
committerSergey Petrunya <psergey@askmonty.org>2011-07-05 01:44:15 +0400
commitc1de6f8b775eba12e09de856078d135e34aa816d (patch)
tree4bec72ecb3e58f4fca52239b3682dea464fe8e33 /mysql-test/t/subselect_mat.test
parent3984062ba40b72aab421db6e31ba80a42e3ad2ae (diff)
downloadmariadb-git-c1de6f8b775eba12e09de856078d135e34aa816d.tar.gz
Change the default @@optimizer_switch setting from
semijoin=on,firstmatch=on,loosescan=on to semijoin=off,firstmatch=off,loosescan=off Adjust the testcases: - Modify subselect*.test and join_cache.test so that all tests use the same execution paths as before (i.e. optimizations that are being tested are enabled) - Let all other test files run with the new default settings (i.e. with new optimizations disabled) - Copy subquery testcases from these files into t/subselect_extra.test which will run them with new optimizations enabled.
Diffstat (limited to 'mysql-test/t/subselect_mat.test')
-rw-r--r--mysql-test/t/subselect_mat.test4
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/subselect_mat.test b/mysql-test/t/subselect_mat.test
index 9d6eb2775ab..172ef651407 100644
--- a/mysql-test/t/subselect_mat.test
+++ b/mysql-test/t/subselect_mat.test
@@ -5,9 +5,11 @@
# force the use of materialization
-set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off';
+set @subselect_mat_test_optimizer_switch_value='materialization=on,in_to_exists=off,semijoin=off';
--source t/subselect_sj_mat.test
+set @subselect_mat_test_optimizer_switch_value=null;
+
set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off';
#
# Test that the contents of the temp table of a materialized subquery is