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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22153 ALTER add default history partitions makes table inaccessible

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

          Activity

            Ascending order - Click to sort in descending order
            midenok Aleksey Midenkov created issue -
            midenok Aleksey Midenkov made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 10.5 [ 23123 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5 [ 23123 ]
            midenok Aleksey Midenkov made changes -
            midenok Aleksey Midenkov made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin added a comment -

            OK

            sanja Oleksandr Byelkin added a comment - OK
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Aleksey Midenkov [ midenok ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            midenok Aleksey Midenkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Component/s Partitioning [ 10802 ]
            Component/s Versioned Tables [ 14303 ]
            Fix Version/s 10.5.3 [ 24263 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 106762 ] MariaDB v4 [ 157562 ]

            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.