diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-12-15 14:26:59 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-12-15 14:26:59 -0800 |
| commit | a910e8ef5b5d33cd600acaba9ec3cc8c49881196 (patch) | |
| tree | ceab0338af1b7b100b069fec4e6be7cf31b48a44 /mysql-test/r/subselect3.result | |
| parent | f5dac20f38fcf581b0616562cd2da21fb8c50218 (diff) | |
| download | mariadb-git-a910e8ef5b5d33cd600acaba9ec3cc8c49881196.tar.gz | |
Made join_cache_level == 2 by default.
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 7d13bce1f85..8d79eb26557 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -1,6 +1,7 @@ drop table if exists t0, t1, t2, t3, t4, t5, t11, t12, t21, t22; set @subselect3_tmp= @@optimizer_switch; set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on,semijoin_with_cache=on'; +set join_cache_level=1; create table t1 (oref int, grp int, ie int) ; insert into t1 (oref, grp, ie) values (1, 1, 1), |