Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21926

rpl.rpl_gtid_basic, rpl.rpl_sp tests fail with --ps-protocol

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.5
    • N/A
    • Tests
    • None

    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
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.