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

mysqlbinlog output ambiguous escaping

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.1, 5.5.30
    • 10.0.2, 5.5.31
    • None
    • N/A

    Description

      With row-level binlogs enabled, the following command can produce ambiguously escaped output:

      $ mysqlbinlog -v --base64-output=DECODE-ROWS master-bin.000001

      To reproduce the issue, I can run the following SQL command (table schema not relevant):

      INSERT INTO `mytest`.`tbl` VALUES ('\n test \\x0a');

      This results in the mysqlbinlog output:

      ### INSERT INTO `mytest`.`tbl`
      		 
      ### SET
      		 
      ###   @1='\x0a test \x0a'

      As you can see, it is impossible to differentiate the output of a new-line character (0x0A) from the un-escaped string "\x0a".

      Attachments

        Issue Links

          links to

          Web Link contributed patch

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            The effect is reproducible on MySQL as well (at least 5.6, but I suppose on previous versions too).
            However, I don't see any problems with replication as such, the events seem to be replicated correctly, so it's just visual representation that's ambiguous.
            You might want to file a bug report or feature request at bugs.mysql.com.

            elenst Elena Stepanova added a comment - The effect is reproducible on MySQL as well (at least 5.6, but I suppose on previous versions too). However, I don't see any problems with replication as such, the events seem to be replicated correctly, so it's just visual representation that's ambiguous. You might want to file a bug report or feature request at bugs.mysql.com.
            monty Michael Widenius added a comment -

            Pushed into 5.5 tree

            monty Michael Widenius added a comment - Pushed into 5.5 tree

            People

              monty Michael Widenius
              icgood Ian Good
              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.