InnoDB-level versioning

Added (IB):

• SYS_VTQ internal InnoDB table;
• INNODB_SYS_VTQ INFORMATION_SCHEMA table:
  • limited to show I_S_SYS_VTQ_LIMIT (10000) of most recent VTQ records;
  • limited to show I_S_MAX_CONCURR_TRX (100) of CONCURR_TRX values;
  • TIMESTAMP fields show fractions of seconds.
• versioned INSERT, UPDATE, DELETE for InnoDB;
• BEGIN_TS(), COMMIT_TS() SQL functions;
• versioned SELECT for InnoDB is translated with COMMIT_TS().

Fixed (SQL):

• FOR_SYSTEM_TIME_UNSPECIFIED condition compares to TIMESTAMP_MAX_VALUE;
• segfault fix #36: multiple execute of prepared stmt;
• different tables to same stored procedure fix (#39).

Known bugs (SQL):

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

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).