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

CONVERT TABLE TO PARTITION: allow copy rows to avoid partition restrictions

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Partitioning
    • None

    Description

      Reproduce

      create or replace table t1 (x int)
      		 
      partition by range columns (x) (
      		 
        partition p0 values less than (10),
      		 
        partition p1 values less than (20),
      		 
        partition pn values less than maxvalue);
      		 
       
      		 
      insert into t1 values (21);
      		 
       
      		 
      alter table t1 convert partition pn to table pn;
      		 
      alter table t1 add partition (partition p2 values less than (30));
      		 
      alter table t1 convert table pn to partition pn values less than maxvalue;

      Result

      alter table t1 convert table pn to partition pn values less than maxvalue;
      		 
      ERROR 1737 (HY000): Found a row that does not match the partition

      Expected

      CONVERT TABLE succeeds, row 21 is moved to partition p2.

      Attachments

        Issue Links

          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27180 Fully atomic partitioning DDL operations

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25495 Auto-drop old history partition for system-versioned tables that use auto-creation

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

          Task - A task that needs to be done. MDEV-31212 Range partition: allow ADD PARTITION into the middle of ranges list

          • Major - Major loss of function.
          • Open

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.