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

Wrong Number of rows in mysqlbinlog output.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.3(EOL), 10.4(EOL), 10.5
    • 10.3.19, 10.4.9
    • Replication
    • None
    • All

    Description

      Following test case different way It print different no of rows the actual rows.

      --source include/have_binlog_format_row.inc
      		 
       
      		 
      --let $MYSQLD_DATADIR= `select @@datadir`
      		 
      --let $binlog_file= $MYSQLD_DATADIR/master-bin.000001
      		 
      --let $output_file= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.output
      		 
       
      		 
      CREATE TABLE t1(c_char_utf8 CHAR(10) ,
      		 
        c_varchar_utf8 char(10) ,
      		 
        c_text_utf8 blob );
      		 
       
      		 
      INSERT into t1   values("B", "B", REPEAT("!", 20000));
      		 
       
      		 
      --exec $MYSQL_BINLOG -F $binlog_file > $output_file
      		 
      --remove_file $output_file
      		 
      drop table t1;

      Output

      ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
      		 
      ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
      		 
      ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEpm2rJ
      		 
      '/*!*/;
      		 
      # Number of rows: 313

      So instead of ! we use # in repeat

      INSERT into t1   values("B", "B", REPEAT("#", 20000));


      IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
      		 
      IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
      		 
      '/*!*/;
      		 
      # Number of rows: 3670


      INSERT into t1   values("B", "B", REPEAT("#", 2000));


      IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
      		 
      IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
      		 
      '/*!*/;
      		 
      # Number of rows: 2

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20582 Asan failure in table_def::calc_field_size

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sachin.setiya.007 Sachin Setiya (Inactive) created issue -
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Field Original Value New Value
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Description Following test case different way It print different no of rows the actual rows.

            {noformat}
            --source include/have_binlog_format_row.inc

            --let $MYSQLD_DATADIR= `select @@datadir`
            --let $binlog_file= $MYSQLD_DATADIR/master-bin.000001
            --let $output_file= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.output

            CREATE TABLE t1(c_char_utf8 CHAR(10) ,
              c_varchar_utf8 char(10) ,
              c_text_utf8 blob );

            INSERT into t1 values("B", "B", REPEAT("!", 20000));

            --exec $MYSQL_BINLOG -F $binlog_file > $output_file
            --remove_file $output_file
            drop table t1;
            {noformat}

            Output
            {noformat}
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEpm2rJ
            '/*!*/;
            # Number of rows: 313
            {noformat}

            So instead of ! we use # in repeat

            {noformat}
            INSERT into t1 values("B", "B", REPEAT("#", 20000));
            {noformat}

            {noformat}
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
            '/*!*/;
            # Number of rows: 3670
            {noformat}

            		Following test case different way It print different no of rows the actual rows.

            {noformat}
            --source include/have_binlog_format_row.inc

            --let $MYSQLD_DATADIR= `select @@datadir`
            --let $binlog_file= $MYSQLD_DATADIR/master-bin.000001
            --let $output_file= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.output

            CREATE TABLE t1(c_char_utf8 CHAR(10) ,
              c_varchar_utf8 char(10) ,
              c_text_utf8 blob );

            INSERT into t1 values("B", "B", REPEAT("!", 20000));

            --exec $MYSQL_BINLOG -F $binlog_file > $output_file
            --remove_file $output_file
            drop table t1;
            {noformat}

            Output
            {noformat}
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
            ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEpm2rJ
            '/*!*/;
            # Number of rows: 313
            {noformat}

            So instead of ! we use # in repeat

            {noformat}
            INSERT into t1 values("B", "B", REPEAT("#", 20000));
            {noformat}

            {noformat}
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
            '/*!*/;
            # Number of rows: 3670
            {noformat}


            {noformat}
            INSERT into t1 values("B", "B", REPEAT("#", 2000));
            {noformat}

            {noformat}
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
            IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
            '/*!*/;
            # Number of rows: 2
            {noformat}
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sachin.setiya.007 Sachin Setiya (Inactive) added a comment -

            http://lists.askmonty.org/pipermail/commits/2019-September/013988.html

            buildbot branch bb-10.3-sachin

            sachin.setiya.007 Sachin Setiya (Inactive) added a comment - http://lists.askmonty.org/pipermail/commits/2019-September/013988.html buildbot branch bb-10.3-sachin
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Michael Widenius [ monty ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            monty Michael Widenius added a comment -

            ok to push

            monty Michael Widenius added a comment - ok to push
            monty Michael Widenius made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Fix Version/s 10.3.19 [ 23908 ]
            Fix Version/s 10.4.9 [ 23906 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 99649 ] MariaDB v4 [ 156746 ]

            People

              monty Michael Widenius
              sachin.setiya.007 Sachin Setiya (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.