diff options
author | Igor Babaev <igor@askmonty.org> | 2011-12-15 00:21:15 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2011-12-15 00:21:15 -0800 |
commit | f5dac20f38fcf581b0616562cd2da21fb8c50218 (patch) | |
tree | bfa94f668924256290b553ee80b1380b1066344c /mysql-test/suite/pbxt/t/join_nested.test | |
parent | efb57a8ebf798eee816981488c901539ec9fcdad (diff) | |
download | mariadb-git-f5dac20f38fcf581b0616562cd2da21fb8c50218.tar.gz |
Made the optimizer switch flags 'outer_join_with_cache', 'semijoin_with_cache'
set to 'on' by default.
Diffstat (limited to 'mysql-test/suite/pbxt/t/join_nested.test')
-rw-r--r-- | mysql-test/suite/pbxt/t/join_nested.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/t/join_nested.test b/mysql-test/suite/pbxt/t/join_nested.test index 98ffcbc9a8a..25c8a5a782e 100644 --- a/mysql-test/suite/pbxt/t/join_nested.test +++ b/mysql-test/suite/pbxt/t/join_nested.test @@ -3,6 +3,9 @@ DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5,t6,t7,t8,t9; --enable_warnings +SET @save_optimizer_switch=@@optimizer_switch; +SET optimizer_switch='outer_join_with_cache=off'; + CREATE TABLE t0 (a int, b int, c int); CREATE TABLE t1 (a int, b int, c int); CREATE TABLE t2 (a int, b int, c int); @@ -1063,6 +1066,9 @@ SELECT t1.*, t4.nm DROP TABLE t1,t2,t3,t4; + +SET optimizer_switch=@save_optimizer_switch; + --disable_query_log drop database pbxt; --enable_query_log |