[MDEV-19938] Reorganize multiple history partitions - Jira

XML

Word

Printable

Implement merging of multiple history partitions by the syntax:

create or replace table t1 (x int) with system versioning

partition by system_time partitions 3;

alter table t1 reorganize partition p0, p1 into (partition p0 history);

Consider implementing splitting into multiple history partitions:

create or replace table t1 (x int) with system versioning

partition by system_time;

alter table t1 reorganize partition p0 into (partition p0 history, partition p1 history);

Splitting distributes rows equally between specified partitions.

For INTERVAL:
Merging and splitting is forbidden.

For LIMIT:
Merging is forbidden when LIMIT is overflown.

Currently splitting and merging fail with error:

ERROR 1510 (HY000): REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers

relates to

MDEV-17554 Auto-create history partitions for system-versioned tables

MDEV-19903 Setup default partitions for system versioning

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.