Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
We are using MariaDB 10.3.
As per: https://mariadb.com/kb/en/temporal-data-tables/
Is it possible to allow the user to explicitly update the ROW_START and ROW_END column in the table row, for a table with SYSTEM VERSIONING enabled?
We sometimes import old data and would like to backfill the data.
Attachments
Issue Links
- is duplicated by
-
MDEV-16029 mysqldump: dump and restore historical data
-
- Closed
-
Yes, it is possible, but not as simple as directly updating these values. For example, the following script will create a historical row as created in 1990-01-01 and deleted one year after:
This can be easily automated with a stored procedure or some external script.
For this approach to work you need @@secure_timestamp variable to be not set to YES.
Allowing direct updates of versioning fields is part of
MDEV-16029