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

ALTER add default history partitions name clash on non-default partitions

Details

    Description

      Reproduce

      --source include/have_partition.inc
      --source include/have_innodb.inc
       
      create or replace table t1 (x int) with system versioning partition by system_time
      (partition p2 history, partition p3 history, partition pn current);
      alter table t1 add partition partitions 1;
      alter table t1 add partition partitions 1;
      alter table t1 add partition partitions 1;
      show create table t1;
       
      drop tables t1;
      

      Result

      mysqltest: At line 6: query 'alter table t1 add partition partitions 1' failed: 1517: Duplicate partition name p2
      

      Expected

      Create partitions on unoccupied names.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            3d 15h 39m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            14s 1
            Oleksandr Byelkin made transition -
            In Review Stalled
            14d 14h 1
            Aleksey Midenkov made transition -
            Stalled In Progress
            2d 22h 39m 1
            Aleksey Midenkov made transition -
            In Progress Closed
            1d 1h 58m 1

            People

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