Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5
-
None
Description
Reproduce
--source include/have_partition.inc
|
--source include/have_innodb.inc
|
|
create or replace table t1 (i int) with system versioning |
partition by system_time limit 1 partitions 5; |
|
alter table t1 drop partition p0, p2; |
show create table t1; |
alter table t1 add partition partitions 1; |
show create table t1; |
|
drop tables t1; |
Result
mysqltest: At line 10: query 'show create table t1' failed: 1017: Can't find file: './test/t1.MYI' (errno: 2 "No such file or directory")
|
Notes
This is continuation of MDEV-22153 bug when contiguity of history partition is broken. ha_partition::open_read_partitions() can not handle non-contiguous list of default partitions.
Fix
When default partition is dropped convert list of partitions to non-default.
Attachments
Issue Links
- relates to
-
MDEV-22153 ALTER add default history partitions makes table inaccessible
- Closed