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, 10 insertions, 2 deletions

diff --git a/mysql-test/main/ctype_recoding.test b/mysql-test/main/ctype_recoding.test
index ba2e65b3626..cc58d4aeff9 100644
--- a/mysql-test/main/ctype_recoding.test
+++ b/mysql-test/main/ctype_recoding.test
@@ -74,11 +74,13 @@ SHOW TABLES IN ����;
 SET CHARACTER SET koi8r;
 DROP DATABASE ����;
 
+# Enable view protocol after fix MDEV-27944
+--disable_view_protocol
 SET NAMES koi8r;
 SELECT hex('����');
 SET character_set_connection=cp1251;
 SELECT hex('����');
-
+--enable_view_protocol
 USE test;
 
 # Bug#4417
@@ -94,9 +96,12 @@ DROP TABLE `тест`;
 SET NAMES binary;
 SET character_set_connection=utf8;
 SELECT 'тест' as s;
+# enable view-protocol in 10.6 version
+--disable_view_protocol
 SET NAMES utf8;
 SET character_set_connection=binary;
 SELECT 'тест' as s;
+--enable_view_protocol
 
 # Bug#4417, another aspect:
 # Check that both "SHOW CREATE TABLE" and "SHOW COLUMNS"
@@ -173,6 +178,8 @@ drop table t1;
 #
 # Check more automatic conversion
 #
+# Enable view protocol after fix MDEV-28017
+--disable_view_protocol
 set names koi8r;
 create table t1 (c1 char(10) character set cp1251);
 insert into t1 values ('�');
@@ -197,7 +204,8 @@ select rpad(c1,3,'�'), rpad('�',3,c1) from t1;
 #select case c1 when '�' then '�' when '�' then '�' else 'c' end from t1;
 #select export_set(5,c1,'�'), export_set(5,'�',c1) from t1;
 drop table t1;
- 
+--enable_view_protocol
+
 #
 # Bug 20695: problem with field default value's character set
 #