[MDEV-21926]  rpl.rpl_gtid_basic, rpl.rpl_sp tests fail with --ps-protocol Created: 2020-03-12  Updated: 2020-03-13  Resolved: 2020-03-13

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-21920 binlog_encryption.rpl_gtid_basic test... Closed

 Description   

10.5 9d7ed94f6a526748eff29

rpl.rpl_gtid_basic 'innodb,mix'          [ fail ]
        Test ended at 2020-03-12 16:46:21
 
CURRENT_TEST: rpl.rpl_gtid_basic
--- /d1/git/10.5/mysql-test/suite/rpl/r/rpl_gtid_basic.result	2020-02-21 10:40:02.023567213 +0000
+++ /d1/git/10.5/mysql-test/suite/rpl/r/rpl_gtid_basic.reject	2020-03-12 16:46:21.476000000 +0000
@@ -3,7 +3,7 @@
 *** GTID position should be empty here ***
 SELECT BINLOG_GTID_POS('<BINLOG_FILE>',<BINLOG_POS>);
 BINLOG_GTID_POS('<BINLOG_FILE>',<BINLOG_POS>)
-
+�8v��U
 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
 CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
 INSERT INTO t1 VALUES (1, "m1");
 
mysqltest: Result length mismatch

rpl.rpl_sp 'mix'                         [ fail ]
        Test ended at 2020-03-12 16:44:09
 
CURRENT_TEST: rpl.rpl_sp
--- /d1/git/10.5/mysql-test/suite/rpl/r/rpl_sp.result	2020-02-21 10:40:02.051568987 +0000
+++ /d1/git/10.5/mysql-test/suite/rpl/r/rpl_sp.reject	2020-03-12 16:44:09.228000000 +0000
@@ -23,7 +23,7 @@
 set b = 8;
 insert into t1 values (b);
 insert into t1 values (unix_timestamp());
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 declare b int;
 set b = 8;
 insert into t1 values (b);
@@ -37,7 +37,7 @@
 set b = 8;
 insert into t1 values (b);
 insert into t1 values (unix_timestamp());
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 declare b int;
 set b = 8;
 insert into t1 values (b);
@@ -140,7 +140,7 @@
 db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_modecomment	character_set_client	collation_connection	db_collation	body_utf8	aggregate
 mysqltest1	foo4	PROCEDURE	foo4	SQL	CONTAINS_SQL	YES	DEFINER			begin
 insert into t2 values(20),(20);
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 insert into t2 values(20),(20);
 end	NONE
 connection master;
@@ -238,17 +238,17 @@
 db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_modecomment	character_set_client	collation_connection	db_collation	body_utf8	aggregate
 mysqltest1	fn1	FUNCTION	fn1	SQL	NO_SQL	NO	DEFINER		int(11)	begin
 return unix_timestamp();
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return unix_timestamp();
 end	NONE
 mysqltest1	fn2	FUNCTION	fn2	SQL	NO_SQL	NO	DEFINER		int(11)	begin
 return unix_timestamp();
-end	zedjzlcsjhd@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	zedjzlcsjhd@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return unix_timestamp();
 end	NONE
 mysqltest1	fn3	FUNCTION	fn3	SQL	READS_SQL_DATA	NO	DEFINER		int(11)	begin
 return 0;
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return 0;
 end	NONE
 select * from t1;
@@ -263,17 +263,17 @@
 db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_modecomment	character_set_client	collation_connection	db_collation	body_utf8	aggregate
 mysqltest1	fn1	FUNCTION	fn1	SQL	NO_SQL	NO	DEFINER		int(11)	begin
 return unix_timestamp();
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return unix_timestamp();
 end	NONE
 mysqltest1	fn2	FUNCTION	fn2	SQL	NO_SQL	NO	DEFINER		int(11)	begin
 return unix_timestamp();
-end	zedjzlcsjhd@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	zedjzlcsjhd@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return unix_timestamp();
 end	NONE
 mysqltest1	fn3	FUNCTION	fn3	SQL	READS_SQL_DATA	NO	DEFINER		int(11)	begin
 return 0;
-end	root@localhost	#	#			latin1	latin1_swedish_ci	latin1_swedish_ci	begin
+end	root@localhost	#	#	�	�	latin1	latin1_swedish_ci	latin1_swedish_ci	begin
 return 0;
 end	NONE
 connection master;
 
mysqltest: Result length mismatch


Generated at Thu Feb 08 09:10:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.