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

WITHOUT VALIDATION for EXCHANGE PARTITION/CONVERT IN

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.
          • Stalled

          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.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            monty Michael Widenius made changes -
            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.

            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.             		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.
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            serg Sergei Golubchik made changes -
            Labels Compatibility
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.6 [ 24028 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.5 [ 23123 ]
            serg Sergei Golubchik made changes -
            Rank Ranked lower
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.6 [ 24028 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.7 [ 24805 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.7 [ 24805 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 106790 ] MariaDB v4 [ 131251 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.8 [ 26121 ]
            julien.fritsch Julien Fritsch made changes -
            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.             		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.
            julien.fritsch Julien Fritsch made changes -
            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.             		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.
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Max Mether [ maxmether ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.9 [ 26905 ]
            maxmether Max Mether made changes -
            AirFocus AirFocus made changes -
            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.             		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.
            julien.fritsch Julien Fritsch made changes -
            Assignee Max Mether [ maxmether ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            midenok Aleksey Midenkov made changes -
            midenok Aleksey Midenkov made changes -
            serg Sergei Golubchik made changes -
            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.             		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}}
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Aleksey Midenkov [ midenok ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Summary Adding support for WITH_VALIDATE to ALTER TABLE EXCHANGE PARTITION WITHOUT CHECK for EXCHANGE PARTITION/CONVERT IN
            midenok Aleksey Midenkov made changes -
            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}}             		Add support for WITH VALIDATION \| WITHOUT VALIDATION to
            ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE

            MySQL has [had this|https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html] 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}}
            midenok Aleksey Midenkov made changes -
            Summary WITHOUT CHECK for EXCHANGE PARTITION/CONVERT IN WITHOUT VALIDATION for EXCHANGE PARTITION/CONVERT IN
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            midenok Aleksey Midenkov made changes -
            Description Add support for WITH VALIDATION \| WITHOUT VALIDATION to
            ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE

            MySQL has [had this|https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html] 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}}             		h3. 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}}

            h3. 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|https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html] 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.
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Aleksey Midenkov [ midenok ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            midenok Aleksey Midenkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Assignee Aleksey Midenkov [ midenok ] Elena Stepanova [ elenst ]
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.4.1 [ 29523 ]
            serg Sergei Golubchik made changes -
            Description h3. 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}}

            h3. 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|https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html] 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.
            		h3. 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}}

            h3. 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|https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html] 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.-
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            elenst Elena Stepanova made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility Compatibility Preview_11.4
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Aleksey Midenkov [ midenok ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 192199

            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.