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

WITHOUT VALIDATION for EXCHANGE PARTITION/CONVERT IN

    XMLWordPrintable

Details

    Description

      Goal

      Add support for WITH VALIDATION | WITHOUT VALIDATION to
      ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE

      WITH VALIDATION should be the default behavior.

      Must also cover CONVERT {TABLE|PARTITION} TO

      Background

      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.

      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.

      h3. Supplemental feature

      Make THAN keyword optional in partition definition of range partitioning.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33125 CHECK TABLE does not recognize corruption after EXCHANGE WITHOUT VALIDATION on system-time partitioning

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33128 WITHOUT VALIDATION allows to insert duplicate values into unique key without a way to repair

          • Major - Major loss of function.
          • Open
          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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20498 Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type == 1' failed upon REBUILD PARTITION

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

          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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33190 Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows

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

          Activity

            People

              midenok Aleksey Midenkov
              monty Michael Widenius
              Votes:
              4 Vote for this issue
              Watchers:
              14 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.