summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_nonrecursive.test
diff options
context:
space:
mode:
authorLena Startseva <lena.startseva@mariadb.com>2022-09-23 19:47:13 +0700
committerLena Startseva <lena.startseva@mariadb.com>2022-09-23 19:47:13 +0700
commit78dcf71e88c86772f89f4ae788079c3619a4d38c (patch)
tree8557a5777219e4e06c15a53ab5633f7ca52b3123 /mysql-test/main/cte_nonrecursive.test
parent0c0a56902898038726342ae11decf4bf5421d339 (diff)
parent72ba96a48eb3e99a967e0489cc79f378e865e3fd (diff)
downloadmariadb-git-78dcf71e88c86772f89f4ae788079c3619a4d38c.tar.gz
Merge branch 'bb-10.3-all-builders' into bb-10.4-all-builders
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 40ccdcdb992..3c758f3526e 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