Details
-
New Feature
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
Description
Enable history partitions rotation with AUTO argument to specify maximum number of partitions kept in the table:
create table t1 (x int) with system versioning |
partition by system_time interval 1 hour auto 25; |
|
create table t1 (x int) with system versioning |
partition by system_time interval 1 month auto 13; |
Or with explicit partitions:
create table t1 (x int) with system versioning |
partition by system_time interval 1 hour auto 25 |
(partition p0 history, partition pn current); |
Attachments
Issue Links
- is blocked by
-
MDEV-17554 Auto-create history partitions for system-versioned tables
-
- Closed
-
- relates to
-
MDEV-31212 Range partition: allow ADD PARTITION into the middle of ranges list
-
- Open
-
-
MDEV-31213 CONVERT TABLE TO PARTITION: allow copy rows to avoid partition restrictions
-
- Open
-
Please reveiw bb-11.2-midenok-MDEV-25495