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

ALTER TABLE ... ENGINE = MERGE is binlogged w/o ddl tag

    XMLWordPrintable

Details

    • Can result in data loss
    • Q1/2026 Server Maintenance

    Description

      In binlog the GTID event for

      ALTER TABLE t3 ENGINE = MERGE UNION (t1,t2)
      

      must have DDL flag, that is mysqlbinlog output would be something like

      #260121 19:51:18 server id 1  end_log_pos 371 CRC32 0x1d25b159  GTID 0-1-1 ddl
      ...
      ALTER TABLE t3 ENGINE = MERGE UNION (t1,t2)}}
      
      

      for the above ALTER group of events.
      This fact is found out by knielsen in MDEV-21107.

      The lack of the DDL flag indeed can cause the MDEV-21107 description assert, and its presence rules out possibilities
      of such execution paths.

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              Elkin Andrei Elkin
              Andrei Elkin Andrei Elkin
              Brandon Nesterenko Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d Original Estimate - 1d
                  1d
                  Remaining:
                  Time Spent - 3d Remaining Estimate - 1d
                  1d
                  Logged:
                  Time Spent - 3d Remaining Estimate - 1d
                  3d

                  Git Integration

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