Comments - System-Versioned Tables
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
to drop a historical partition use DROP PARTITION. To add a historical partition use ADD PARTITION. Like
You have described how to create partitions when creating the table. Is it also possible to add it later? I tried to add a partition, but unfortunately I couldn't do that: Both failed:
The syntax for adding partitioning to a not partitioned table would be
alter table t1 partition by SYSTEM_TIME (partition p_hist history, partition p_cur current);
"add" only can be used for already partitioned tables.
Thank you. For one Table it worked. But for another table, this error occurred:
Cannot delete or update a parent row: a foreign key constraint fails
What have I done wrong?
OK, I found in the documentation of partitioning limitations: A partitioned table cannot contain, or be referenced by, foreign keys
This is a pity.
See https://jira.mariadb.org/browse/MDEV-12483