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

mysqlbinlog --verbose shows incorrect values for timestamps >= 2^31 if binlog was created with mysql56_temporal_format=off

    XMLWordPrintable

Details

    Description

      --source include/have_binlog_format_row.inc
      		 
       
      		 
      set @format.save= @@mysql56_temporal_format;
      		 
      set global mysql56_temporal_format= off;
      		 
       
      		 
      create table t (a timestamp);
      		 
      insert into t values (from_unixtime(power(2,31)));
      		 
       
      		 
      --let $datadir= `select @@datadir`
      		 
      flush binary logs;
      		 
      --exec $MYSQL_BINLOG --verbose $datadir/master-bin.000001
      		 
       
      		 
      drop table t;
      		 
      set global mysql56_temporal_format= @format.save;

      bb-11.3-timestamp fd6689da3fffc4d57d8ebde5f8776aefa8cdb8a4

      		 
      ### INSERT INTO `test`.`t`
      		 
      ### SET
      		 
      ###   @1=-2147483648

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14760 Replication does not take into account SET STATEMENT

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32929 mysqlbinlog --verbose fails if binlog was created with mysql56_temporal_format=off

          • Major - Major loss of function.
          • Open

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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