From 72ba96a48eb3e99a967e0489cc79f378e865e3fd Mon Sep 17 00:00:00 2001 From: Lena Startseva Date: Thu, 9 Jun 2022 10:32:51 +0700 Subject: 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. --- mysql-test/main/intersect.test | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/main/intersect.test') diff --git a/mysql-test/main/intersect.test b/mysql-test/main/intersect.test index 901f471121f..08aafb44e41 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; -- cgit v1.2.1 From 184e65954b88266bd426de1c82973bf54a88afb1 Mon Sep 17 00:00:00 2001 From: Lena Startseva Date: Thu, 15 Sep 2022 18:30:13 +0700 Subject: MDEV-27691: make working view-protocol Update tests for version 10.4 --- mysql-test/main/intersect.test | 3 --- 1 file changed, 3 deletions(-) (limited to 'mysql-test/main/intersect.test') diff --git a/mysql-test/main/intersect.test b/mysql-test/main/intersect.test index 9170431692a..31cfcf00c5f 100644 --- a/mysql-test/main/intersect.test +++ b/mysql-test/main/intersect.test @@ -216,13 +216,10 @@ 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; -- cgit v1.2.1