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.

1 files changed, 15 insertions, 1 deletions

diff --git a/mysql-test/main/func_in.test b/mysql-test/main/func_in.test
index b99fad159c2..7ac34e73995 100644
--- a/mysql-test/main/func_in.test
+++ b/mysql-test/main/func_in.test
@@ -354,6 +354,8 @@ SELECT HEX(a) FROM t2 WHERE a IN
 SELECT HEX(a) FROM t2 WHERE a IN 
   (CAST(0x7ffffffffffffffe AS UNSIGNED), 
    CAST(0x7fffffffffffffff AS UNSIGNED));
+#view protocol generates additional warning
+--disable_view_protocol
 SELECT HEX(a) FROM t2 WHERE a IN 
   (0x7ffffffffffffffe, 
    0x7fffffffffffffff,
@@ -368,6 +370,8 @@ CREATE TABLE t4 (a DATE);
 INSERT INTO t4 VALUES ('1972-02-06'), ('1972-07-29');
 SELECT * FROM t4 WHERE a IN ('1972-02-06','19772-07-29');
 
+--enable_view_protocol
+
 DROP TABLE t1,t2,t3,t4;
 
 #
@@ -402,8 +406,11 @@ create table t2(f2 int, index t2f2(f2));
 insert into t2 values(0),(1),(2);
 select f2 from t2 where f2 in ('a',2);
 explain select f2 from t2 where f2 in ('a',2);
+#view protocol generates additional warning
+--disable_view_protocol
 select f2 from t2 where f2 in ('a','b');
 explain select f2 from t2 where f2 in ('a','b');
+--enable_view_protocol
 select f2 from t2 where f2 in (1,'b');
 explain select f2 from t2 where f2 in (1,'b');
 drop table t1, t2;
@@ -658,12 +665,14 @@ DROP TABLE t1;
 --echo #
 --echo # MDEV-11514 IN with a mixture of TIME and DATETIME returns a wrong result
 --echo #
-
+#enable after fix MDEV-27871
+--disable_view_protocol
 SELECT TIME'10:20:30' IN (102030,TIME'10:20:31',TIMESTAMP'2001-01-01 10:20:32');
 PREPARE stmt FROM "SELECT TIME'10:20:30' IN (102030,TIME'10:20:31',TIMESTAMP'2001-01-01 10:20:32')";
 EXECUTE stmt;
 EXECUTE stmt;
 DEALLOCATE PREPARE stmt;
+--enable_view_protocol
 
 --echo #
 --echo # MDEV-11497 Wrong result for (int_expr IN (mixture of signed and unsigned expressions))
@@ -686,7 +695,12 @@ DROP TABLE t1;
 # when using Arg_comparator (e.g. in binary comparison operators), and
 # when not using it (e.g. in IN predicate).
 
+#view protocol generates additional warning
+--disable_view_protocol
 SELECT
   TIME'00:00:00'='' AS c1_true,
   TIME'00:00:00' IN ('', TIME'10:20:30') AS c2_true,
   TIME'00:00:00' NOT IN ('', TIME'10:20:30') AS c3_false;
+
+--enable_view_protocol
+