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

mysqlbinlog produces syntactically incorrect output with system_versioning_insert_history

    XMLWordPrintable

Details

    Description

      --source include/have_log_bin.inc
       
      create table t (a int) with system versioning;
      set system_versioning_insert_history= on;
      insert into t (a) values (1);
      drop table t;
       
      flush binary logs;
      --let $datadir=`select @@datadir`
      --exec $MYSQL_BINLOG --verbose --base64-output=DECODE-ROWS $datadir/master-bin.000001 | $MYSQL test
       
      # Cleanup
       
      --connection master
      drop table t;
      

      bb-10.11-MDEV-16546 2b1d32429

      ERROR 1064 (42000) at line 40: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
      mysqltest: At line 10: exec of '<dir>/client//mysqlbinlog --defaults-file=<dir>/mysql-test/var/my.cnf --local-load=<dir>/mysql-test/var/tmp --verbose --base64-output=DECODE-ROWS <dir>/mysql-test/var/mysqld.1/data//master-bin.000001 | <dir>/client//mysql --defaults-file=<dir>/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 11
      

      Line 40 is

      38:#221007  2:49:13 server id 1  end_log_pos 633 CRC32 0x3f5bf80d 	Query	thread_id=5	exec_time=0	error_code=0	xid=0
      39:SET TIMESTAMP=1665100153.312923/*!*/;
      40:SET /*!*/;
      41:insert into t (a) values (1)
      42:/*!*/;
      43:# at 633
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              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.