[MDEV-19627] Using Bitemporal Table adding WITH SYSTEM VERSIONING to create statement Created: 2019-05-29  Updated: 2019-06-05  Resolved: 2019-06-05

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Shahriyar Rzayev (Inactive) Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: Documentation, docs


 Description   

Doc link:
https://mariadb.com/kb/en/library/temporal-data-tables/#using-bitemporal-tables

The provided create statement failed as:

MariaDB [test]> CREATE TABLE test.t3 (
 
    ->    date_1 DATE,
 
    ->    date_2 DATE,
 
    ->    row_start TIMESTAMP(6) AS ROW START INVISIBLE,
 
    ->    row_end TIMESTAMP(6) AS ROW END INVISIBLE,
 
    ->    PERIOD FOR application_time(date_1, date_2),
 
    ->    PERIOD FOR system_time(row_start, row_end));
 
ERROR 4125 (HY000): Wrong parameters for `t3`: missing 'WITH SYSTEM VERSIONING'

So it should be replaced by:

CREATE TABLE test.t3 (
 
   date_1 DATE,
 
   date_2 DATE,
 
   row_start TIMESTAMP(6) AS ROW START INVISIBLE,
 
   row_end TIMESTAMP(6) AS ROW END INVISIBLE,
 
   PERIOD FOR application_time(date_1, date_2),
 
   PERIOD FOR system_time(row_start, row_end)) WITH SYSTEM VERSIONING;



 Comments   
Comment by Kenneth Dyer (Inactive) [ 2019-06-05 ]

Fixed.

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