summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_nonrecursive.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.test')
-rw-r--r--mysql-test/main/cte_nonrecursive.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.test b/mysql-test/main/cte_nonrecursive.test
index c21090fbdc3..79e2bc838a2 100644
--- a/mysql-test/main/cte_nonrecursive.test
+++ b/mysql-test/main/cte_nonrecursive.test
@@ -1036,6 +1036,8 @@ drop table t1;
--echo # MDEV-16473: query with CTE when no database is set
--echo #
+# Enable view protocol after fix MDEV-27944
+--disable_view_protocol
create database db_mdev_16473;
use db_mdev_16473;
drop database db_mdev_16473;
@@ -1059,6 +1061,7 @@ select * from cte, db_mdev_16473.t1 as t where cte.a=t.a;
drop database db_mdev_16473;
use test;
+--enable_view_protocol
--echo #
--echo # MDEV-17154: using parameter markers for PS within CTEs more than once
@@ -1205,6 +1208,8 @@ DROP TABLE test.t;
--echo # MDEV-22781: create view with CTE without default database
--echo #
+# Enable view protocol after fix MDEV-27944
+--disable_view_protocol
create database db;
use db;
drop database db;
@@ -1230,6 +1235,7 @@ drop table db1.t1;
drop database db1;
use test;
+--enable_view_protocol
--echo #
--echo # MDEV-24597: CTE with union used multiple times in query