SQL-level versioning

Added:

• CREATE TABLE supports clauses:

  • WITH SYSTEM VERSIONING;
  • GENERATED ALWAYS AS ROW START/END;
  • PERIOD FOR SYSTEM_TIME.

  All these clauses are explicit-only.

• SELECT from versioned table supports clauses:

  • FOR SYSTEM_TIME;
  • AS OF TIMESTAMP ..;
  • FROM TIMESTAMP .. TO TIMESTAMP ..;
  • BETWEEN TIMESTAMP .. AND TIMESTAMP ...

• INSERT/UPDATE/DELETE work with versioned tables.

Known bugs:

• Incorrect INNER JOIN (ded545b);
• Incorrect LEFT/RIGH JOIN (262e6ee).