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

Missing binlog data for INSERT .. ON DUPLICATE KEY UPDATE

    XMLWordPrintable

    Details

      Description

      Using the following test case, the second INSERT statement is not logged in the binlog when using MIXED binlog format and thus is not replicated to a slave, leading to inconsistent state of replication.

      Server version: 10.3.34-MariaDB-log MariaDB Server

      CREATE TABLE t1 (
          id INT PRIMARY KEY AUTO_INCREMENT,
          a INT,
          b INT,
          c INT,
          UNIQUE (a),
          UNIQUE (b)
      );
       
      INSERT INTO t1 (`a`,`c`) VALUES (1,1), (2,1) ON DUPLICATE KEY UPDATE c = 1;
      INSERT INTO t1 (`a`,`c`) VALUES (3, 1),(2,1), (1,1) ON DUPLICATE KEY UPDATE c = 1;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              vnsavage Iliya Polihronov
              Votes:
              4 Vote for this issue
              Watchers:
              9 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.