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/join_cache.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/join_cache.test')
-rw-r--r-- | mysql-test/t/join_cache.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/join_cache.test b/mysql-test/t/join_cache.test index 1d5addeb808..aac55dcb27b 100644 --- a/mysql-test/t/join_cache.test +++ b/mysql-test/t/join_cache.test @@ -4,6 +4,7 @@ DROP DATABASE IF EXISTS world; --enable_warnings set @save_optimizer_switch=@@optimizer_switch; +set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on'; set @@optimizer_switch='semijoin_with_cache=on'; set @@optimizer_switch='outer_join_with_cache=on'; |