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.

      Should also cover CONVERT {TABLE|PARTITION} TO

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-22162 Make partitions more flexible to use

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-22165 CONVERT TABLE: move in partition from existing table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-22166 CONVERT PARTITION: move out partition into a table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-28298 Add Foreign key to a table instantly without checking existing data

          • Major - Major loss of function.
          • Open

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              monty Michael Widenius
              Votes:
              4 Vote for this issue
              Watchers:
              9 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.