Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19938

Reorganize multiple history partitions

    Details

      Description

      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);
      

      While usefulness of merging is obvious the splitting is not so evident. Probably may be used in conjunction with INTERVAL or LIMIT.

      Currently both variants fail with error:

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

      More observations

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                midenok Aleksey Midenkov
                Reporter:
                midenok Aleksey Midenkov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: