summaryrefslogtreecommitdiff
path: root/mysql-test/suite/pbxt/t/join_nested.test
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2011-12-15 00:21:15 -0800
committerIgor Babaev <igor@askmonty.org>2011-12-15 00:21:15 -0800
commitf5dac20f38fcf581b0616562cd2da21fb8c50218 (patch)
treebfa94f668924256290b553ee80b1380b1066344c /mysql-test/suite/pbxt/t/join_nested.test
parentefb57a8ebf798eee816981488c901539ec9fcdad (diff)
downloadmariadb-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.test6
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