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/subselect_sj2.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/subselect_sj2.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj2.result b/mysql-test/r/subselect_sj2.result index 45dd12a6b77..7a770abb474 100644 --- a/mysql-test/r/subselect_sj2.result +++ b/mysql-test/r/subselect_sj2.result @@ -1,3 +1,5 @@ +set @subselect_sj2_tmp= @@optimizer_switch; +set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on'; drop table if exists t0, t1, t2, t3; drop view if exists v1; create table t0 (a int); @@ -744,3 +746,4 @@ LEFT JOIN t2 AS SQ4_alias3 ON SQ4_alias3.f10 GROUP BY field2; field2 drop table t1, t2, t3; +set optimizer_switch=@subselect_sj2_tmp; |