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

              Assignee:
              Unassigned Unassigned
              Reporter:
              monty Michael Widenius
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration