summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_nonrecursive.test
diff options
context:
space:
mode:
authorLena Startseva <lena.startseva@mariadb.com>2022-06-09 10:32:51 +0700
committerLena Startseva <lena.startseva@mariadb.com>2022-09-23 17:36:20 +0700
commit72ba96a48eb3e99a967e0489cc79f378e865e3fd (patch)
treed68b640bd3b6f71c4c7e13967776a13aa29965a2 /mysql-test/main/cte_nonrecursive.test
parent1dd6255ffef901dddcff2191ddf975a2019799d9 (diff)
downloadmariadb-git-72ba96a48eb3e99a967e0489cc79f378e865e3fd.tar.gz
MDEV-27691: make working view-protocol
Tests with checking metadata or that cannot be run with the view-protocol are excluded from --view-protocol. For tests that do not allow the use of an additional connection, the util connection is disabled with "--disable_service_connection". Also cases with bugs for --view-protocol are disabled.
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