[MDEV-19903] Setup default partitions for system versioning Created: 2019-06-28  Updated: 2021-12-21  Resolved: 2019-11-22

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Fix Version/s: 10.5.0

Type: Task Priority: Major
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-27328 Change of SYSTEM_TIME partitioning op... Closed
Problem/Incident
causes MDEV-22153 ALTER add default history partitions ... Closed
Relates
relates to MDEV-17554 Auto-create history partitions for sy... Closed
relates to MDEV-19938 Reorganize multiple history partitions Open
relates to MDEV-22112 Assertion `tab_part_info->part_type =... Closed

 Description   

Currently such syntax fails:

create table t1 (i int) with system versioning partition by system_time;

with error message:

ERROR 1492 (HY000): For LIST partitions each partition must be defined

which is by itself incorrect.

Auto-create 1 history partition and 1 working partition for the above syntax. Specify the number of history partitions by the partitions keyword:

create table t1 (i int) with system versioning partition by system_time partitions 2;

This should create 1 history and 1 working partition. The working partition is mandatory, so partitions 1 should fail with error.


Generated at Thu Feb 08 08:55:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.