summaryrefslogtreecommitdiff
path: root/mysql-test/main/intersect.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2022-10-14 09:04:54 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2022-10-14 09:04:54 +0200
commit7cad2e94b1664a2185b873bc6f801b98fcefa817 (patch)
tree5aa2feff7ca99a0e857c892fe8685f774a9e8a70 /mysql-test/main/intersect.test
parent0cddb1ac99cbecaddd08bfe5355c034c01c0c406 (diff)
parent184e65954b88266bd426de1c82973bf54a88afb1 (diff)
downloadmariadb-git-7cad2e94b1664a2185b873bc6f801b98fcefa817.tar.gz
Merge branch 'bb-10.4-vp-MDEV-27691' into 10.4
Diffstat (limited to 'mysql-test/main/intersect.test')
-rw-r--r--mysql-test/main/intersect.test3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/intersect.test b/mysql-test/main/intersect.test
index 18c95d62d44..31cfcf00c5f 100644
--- a/mysql-test/main/intersect.test
+++ b/mysql-test/main/intersect.test
@@ -317,12 +317,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;