diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 7486ffc38f8..821bbe055e6 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -5,6 +5,9 @@ drop database if exists mysqltest; --enable_warnings use test; +SET @save_optimizer_switch=@@optimizer_switch; +SET optimizer_switch='outer_join_with_cache=off'; + # # some basic test of views and its functionality # @@ -4308,3 +4311,5 @@ SELECT * FROM t1 RIGHT JOIN v2 ON ( v2.a = t1.a ) WHERE v2.b IN ( SELECT b FROM DROP VIEW v2; DROP TABLE t1, t2, t3; + +SET optimizer_switch=@save_optimizer_switch; |