Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
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.
Attachments
Issue Links
- blocks
-
MDEV-27328 Change of SYSTEM_TIME partitioning options is not possible without data copy
- Closed
- causes
-
MDEV-22153 ALTER add default history partitions makes table inaccessible
- Closed
- relates to
-
MDEV-17554 Auto-create history partitions for system-versioned tables
- Closed
-
MDEV-19938 Reorganize multiple history partitions
- Open
-
MDEV-22112 Assertion `tab_part_info->part_type == RANGE_PARTITION || tab_part_info->part_type == LIST_PARTITION' failed in prep_alter_part_table
- Closed