Details
-
Type:
Task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Fix Version/s: 10.11
-
Component/s: Partitioning, Versioned Tables
-
Labels:None
Description
Enable history rotation with MAX keyword:
create table t1 (x int) with system versioning |
partition by system_time interval 1 hour auto max 24; |
 |
create table t1 (x int) with system versioning |
partition by system_time interval 1 month auto max 12; |
Or with explicit partitions:
create table t1 (x int) with system versioning |
partition by system_time interval 1 hour auto max 24 |
(partition p0 history, partition pn current); |
Attachments
Issue Links
- is blocked by
-
MDEV-17554 Auto-create history partitions for system-versioned tables
-
- Closed
-