diff options
Diffstat (limited to 'mysql-test/main/intersect.test')
-rw-r--r-- | mysql-test/main/intersect.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/intersect.test b/mysql-test/main/intersect.test index 901f471121f..08aafb44e41 100644 --- a/mysql-test/main/intersect.test +++ b/mysql-test/main/intersect.test @@ -216,10 +216,13 @@ CREATE TABLE t (i INT); INSERT INTO t VALUES (1),(2); SELECT * FROM t WHERE i != ANY ( SELECT 6 INTERSECT SELECT 3 ); +#enable view protocol in 10.4 +--disable_view_protocol select i from t where exists ((select 6 as r from dual having t.i <> 6) intersect (select 3 from dual having t.i <> 3)); +--enable_view_protocol drop table t; @@ -317,12 +320,15 @@ insert into t234 values(2); insert into t234 values(3); insert into t234 values(4); +#enable view protocol in 10.5 +--disable_view_protocol set SQL_MODE=oracle; --sorted_result select * from t13 union select * from t234 intersect select * from t12; set SQL_MODE=default; --sorted_result select * from t13 union select * from t234 intersect select * from t12; +--enable_view_protocol drop table t12,t13,t234; |