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/derived_view.test | |
| parent | f5dac20f38fcf581b0616562cd2da21fb8c50218 (diff) | |
| download | mariadb-git-a910e8ef5b5d33cd600acaba9ec3cc8c49881196.tar.gz | |
Made join_cache_level == 2 by default.
Diffstat (limited to 'mysql-test/t/derived_view.test')
| -rw-r--r-- | mysql-test/t/derived_view.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/derived_view.test b/mysql-test/t/derived_view.test index 953a4c8fcef..581d01058db 100644 --- a/mysql-test/t/derived_view.test +++ b/mysql-test/t/derived_view.test @@ -4,9 +4,11 @@ drop view if exists v1,v2,v3,v4; --enable_warnings set @exit_optimizer_switch=@@optimizer_switch; +set @exit_join_cache_level=@@join_cache_level; set optimizer_switch='derived_merge=on,derived_with_keys=on'; # The 'default' value within the scope of this test: set @save_optimizer_switch=@@optimizer_switch; +set join_cache_level=1; create table t1(f1 int, f11 int); create table t2(f2 int, f22 int); @@ -1276,3 +1278,4 @@ drop table t1,t2,t3; # The following command must be the last one the file set optimizer_switch=@exit_optimizer_switch; +set join_cache_level=@exit_join_cache_level; |