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/greedy_optimizer.test | |
| parent | f5dac20f38fcf581b0616562cd2da21fb8c50218 (diff) | |
| download | mariadb-git-a910e8ef5b5d33cd600acaba9ec3cc8c49881196.tar.gz | |
Made join_cache_level == 2 by default.
Diffstat (limited to 'mysql-test/t/greedy_optimizer.test')
| -rw-r--r-- | mysql-test/t/greedy_optimizer.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/greedy_optimizer.test b/mysql-test/t/greedy_optimizer.test index 5131c97f122..8f969f2562a 100644 --- a/mysql-test/t/greedy_optimizer.test +++ b/mysql-test/t/greedy_optimizer.test @@ -10,6 +10,9 @@ drop table if exists t1,t2,t3,t4,t5,t6,t7; --enable_warnings +set @save_join_cache_level=@@join_cache_level; +set join_cache_level=1; + create table t1 ( c11 integer,c12 integer,c13 integer,c14 integer,c15 integer,c16 integer, primary key (c11) @@ -384,3 +387,5 @@ SET optimizer_search_depth = DEFAULT; DROP TABLE t1,t2,t2_1,t3,t3_1,t4,t4_1,t5,t5_1; --echo End of 5.0 tests + +set join_cache_level=@save_join_cache_level; |