Skip to content

Support for system versioned tables #235

Open

Description

@williamdes
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

Activity

  1. added this to the 4.7.3 milestone on Aug 31, 2021
  2. modified the milestones: 4.7.3, 4.7.4 on Dec 11, 2021
  3. modified the milestones: 4.7.4, 5.7.0 on Nov 21, 2022
  4. modified the milestones: 5.7.0, 5.8.0 on Jan 25, 2023
  5. modified the milestones: 5.8.0, 5.9.0 on Jun 5, 2023
  6. removed this from the 5.8.1 milestone on Sep 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions