Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
As per this comment of MDEV-17553 allow multiple intervals on per-partition basis.
Allow ALTER command to set new rotation INTERVAL while keeping old partitions intact. This involves storing of start timestamp and interval for each partition for pruning to work correctly. The new INTERVAL should be applied to unused partitions as well as to auto-created ones.
When partitions listed explicitly in CREATE TABLE, allow explicit setting of STARTS and INTERVAL per each partition. This information must be reflected in SHOW CREATE (and after ALTER changing the INTERVAL). INFORMATION_SCHEMA should display effective INTERVAL and STARTS per each partition.
Attachments
Issue Links
- relates to
-
MDEV-17553 Enable setting start datetime for interval partitioned history of system versioned tables
- Closed
-
MDEV-17554 Auto-create history partitions for system-versioned tables
- Closed
-
MDEV-29280 wrong metadata definition
- Closed