diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2011-07-05 01:44:15 +0400 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2011-07-05 01:44:15 +0400 |
commit | c1de6f8b775eba12e09de856078d135e34aa816d (patch) | |
tree | 4bec72ecb3e58f4fca52239b3682dea464fe8e33 /mysql-test/t/subselect_mat.test | |
parent | 3984062ba40b72aab421db6e31ba80a42e3ad2ae (diff) | |
download | mariadb-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.test | 4 |
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 |