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

Adding support for WITH_VALIDATE to ALTER TABLE EXCHANGE PARTITION

    XMLWordPrintable

Details

    Description

      Add support for WITH VALIDATE | WITHOUT VALIDATE to
      ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE
      MySQL has had this since 5.7.5 and it's important when adding big tables to a partitioned table to avoid the expensive row-by-row check.

      When WITHOUT VALIDATION is specified, there is no check that all rows in the added table fulfills the partition restrictions. If there is inconsistencies, it will result in rows later not being found in SELECT, UPDATE or DELETE.

      WITH VALIDATION should be the default behavior.

      Attachments

        Issue Links

          Activity

            People

              maxmether Max Mether
              monty Michael Widenius
              Votes:
              4 Vote for this issue
              Watchers:
              8 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.