summaryrefslogtreecommitdiff
path: root/mysql-test/suite/pbxt/r/join_outer.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/pbxt/r/join_outer.result')
-rw-r--r--mysql-test/suite/pbxt/r/join_outer.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/r/join_outer.result b/mysql-test/suite/pbxt/r/join_outer.result
index 496095680ce..a556049b8cc 100644
--- a/mysql-test/suite/pbxt/r/join_outer.result
+++ b/mysql-test/suite/pbxt/r/join_outer.result
@@ -1,4 +1,6 @@
drop table if exists t0,t1,t2,t3,t4,t5;
+SET @save_optimizer_switch=@@optimizer_switch;
+SET optimizer_switch='outer_join_with_cache=off';
CREATE TABLE t1 (
grp int(11) default NULL,
a bigint(20) unsigned default NULL,
@@ -1198,3 +1200,4 @@ a b
3 3
4 NULL
DROP TABLE t1,t2;
+SET optimizer_switch=@save_optimizer_switch;