[MDEV-22155] ALTER add default history partitions name clash on non-default partitions Created: 2020-04-06  Updated: 2022-05-06  Resolved: 2020-04-28

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Affects Version/s: 10.5
Fix Version/s: 10.5.3

Type: Bug Priority: Critical
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
Relates
relates to MDEV-22153 ALTER add default history partitions ... Closed

 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.

 Comments   
Comment by Oleksandr Byelkin [ 2020-04-24 ]

OK

Generated at Thu Feb 08 09:12:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.