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/r/subselect2.result | |
| 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/r/subselect2.result')
| -rw-r--r-- | mysql-test/r/subselect2.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/subselect2.result b/mysql-test/r/subselect2.result index 16273711a49..4fd86f10530 100644 --- a/mysql-test/r/subselect2.result +++ b/mysql-test/r/subselect2.result @@ -1,4 +1,6 @@ drop table if exists t1, t2, t3, t4; +set @subselect2_test_tmp=@@optimizer_switch; +set optimizer_switch='semijoin=on,firstmatch=on'; CREATE TABLE t1 ( DOCID VARCHAR(32)BINARY NOT NULL @@ -144,3 +146,4 @@ and t2.a='1' AND t1.a=t3.b) > 0; a 2 DROP TABLE t1,t2,t3; +set optimizer_switch=@subselect2_test_tmp; |