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

rpl.rpl_row_mysqlbinlog test fails if row annotation enabled

    XMLWordPrintable

Details

    Description

      How to repeat :

      $ perl mtr rpl_row_mysqlbinlog --mysqld=--binlog-annotate-row-events=1
      ...
      rpl.rpl_row_mysqlbinlog 'row'            [ fail ]
              Test ended at 2016-10-20 18:10:44
       
      CURRENT_TEST: rpl.rpl_row_mysqlbinlog
      --- /home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/suite/rpl/r/rpl_row_mysqlbinlog.result	2016-09-30 09:11:25.000000000 -0400
      +++ /home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/suite/rpl/r/rpl_row_mysqlbinlog.reject	2016-10-20 18:10:44.684210000 -0400
      @@ -218,13 +218,13 @@
       include/wait_for_slave_to_start.inc
       SELECT COUNT(*) from t1;
       COUNT(*)
      -352
      +351
       SELECT COUNT(*) from t2;
       COUNT(*)
      -500
      +267
       SELECT COUNT(*) from t3;
       COUNT(*)
      -500
      +267
       SELECT * FROM t1 ORDER BY word LIMIT 5;
       word
       Aarhus
      @@ -241,20 +241,20 @@
       5
       SELECT c1, c3, c4, c5  FROM t3 ORDER BY c1 LIMIT 5;
       c1	c3	c4	c5
      -1	2006-02-22 00:00:00	Tested in Texas	2.2
      -2	2006-02-22 00:00:00	Tested in Texas	4.4
      -3	2006-02-22 00:00:00	Tested in Texas	6.6
      -4	2006-02-22 00:00:00	Tested in Texas	8.8
      -5	2006-02-22 00:00:00	Tested in Texas	11
      +234	2006-02-22 00:00:00	Tested in Texas	514.8
      +235	2006-02-22 00:00:00	Tested in Texas	517
      +236	2006-02-22 00:00:00	Tested in Texas	519.2
      +237	2006-02-22 00:00:00	Tested in Texas	521.4
      +238	2006-02-22 00:00:00	Tested in Texas	523.6
       SELECT COUNT(*) from t1;
       COUNT(*)
      -352
      +351
       SELECT COUNT(*) from t2;
       COUNT(*)
      -500
      +267
       SELECT COUNT(*) from t3;
       COUNT(*)
      -500
      +267
       SELECT * FROM t1 ORDER BY word LIMIT 5;
       word
       Aarhus
      @@ -271,11 +271,11 @@
       5
       SELECT c1, c3, c4, c5  FROM t3 ORDER BY c1 LIMIT 5;
       c1	c3	c4	c5
      -1	2006-02-22 00:00:00	Tested in Texas	2.2
      -2	2006-02-22 00:00:00	Tested in Texas	4.4
      -3	2006-02-22 00:00:00	Tested in Texas	6.6
      -4	2006-02-22 00:00:00	Tested in Texas	8.8
      -5	2006-02-22 00:00:00	Tested in Texas	11
      +234	2006-02-22 00:00:00	Tested in Texas	514.8
      +235	2006-02-22 00:00:00	Tested in Texas	517
      +236	2006-02-22 00:00:00	Tested in Texas	519.2
      +237	2006-02-22 00:00:00	Tested in Texas	521.4
      +238	2006-02-22 00:00:00	Tested in Texas	523.6
       --- Test 5 LOAD DATA --
      

      I haven't been able to reduce the test case, but looks like its related to mysqlbinlog's --read-from-remote-server.

      Attachments

        Issue Links

          Activity

            People

              sujatha.sivakumar Sujatha Sivakumar (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.