1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/intersect.test b/mysql-test/main/intersect.test
index 18c95d62d44..9170431692a 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;