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/t/join_outer.test | |
| parent | f5dac20f38fcf581b0616562cd2da21fb8c50218 (diff) | |
| download | mariadb-git-a910e8ef5b5d33cd600acaba9ec3cc8c49881196.tar.gz | |
Made join_cache_level == 2 by default.
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 3bd5532ada0..04816402205 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -10,7 +10,14 @@ drop table if exists t0,t1,t2,t3,t4,t5; SET @save_optimizer_switch=@@optimizer_switch; SET optimizer_switch=ifnull(@optimizer_switch_for_join_outer_test,'outer_join_with_cache=off'); - +if (`select @join_cache_level_for_join_outer_test is null`) +{ + set join_cache_level=1; +} +if (`select @join_cache_level_for_join_outer_test is not null`) +{ + set join_cache_level=@join_cache_level_for_join_outer_test; +} CREATE TABLE t1 ( grp int(11) default NULL, |