sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

Support for system versioned tables

Open williamdes opened this issue 6 years ago • 0 comments

CREATE TABLE t(
   x INT,
   start_timestamp TIMESTAMP(6) GENERATED ALWAYS AS ROW START,
   end_timestamp TIMESTAMP(6) GENERATED ALWAYS AS ROW END,
   PERIOD FOR SYSTEM_TIME(start_timestamp, end_timestamp)
) WITH SYSTEM VERSIONING;

https://mariadb.com/kb/en/library/system-versioned-tables/

This query is valid and works fine, some cases are missing to successfully parse this query

williamdes avatar Mar 30 '19 11:03 williamdes