Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12894

System-versioned tables

Details

    • 10.3.1-1, 10.3.1-2, 10.1.30

    Description

      Implement support for "System-versioned tables" as in SQL:2016.

      Clauses PERIOD SYSTEM_TIME, WITH SYSTEM VERSIONING, FOR SYSTEM_TIME AS OF, FOR SYSTEM_TIME BETWEEN ... AND, FOR SYSTEM_TIME FROM ... TO.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26928 Column-inclusive WITH SYSTEM VERSIONING doesn't work with explicit system fields

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-26934 ADD SYSTEM VERSIONING and modify column WITHOUT SYSTEM VERSIONING in single ALTER TABLE command

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-26993 Add system versioning via modify column WITH SYSTEM VERSIONING

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26994 Transaction-precise tables ignore most recent row versions when queried with "FOR SYSTEM_TIME FROM ts TO ts"

          • Major - Major loss of function.
          • Stalled
          duplicates

          Task - A task that needs to be done. MDEV-12739 Preserve data in a non-rewriteable and non-erasable format

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14556 inconsistent NOW behavior DEFAULT/ASOF

          • Major - Major loss of function.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-10177 Invisible columns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14660 Assertion failure in lock_move_rec_list_start() after instant ADD COLUMN

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14825 Assertion `col->ord_part' in row_build_index_entry_low upon ROLLBACK or DELETE with concurrent ALTER on partitioned table

          • Major - Major loss of function.
          • Closed

          Activity

            serg Sergei Golubchik added a comment -

            Assorted notes:

            • SQL Standard only has FOR SYSTEM_TIME with AS OF ...| FROM ... TO ...| BETWEEN ... AND ... and it can only directly follow a table name in the FROM clause. Does not apply to a view, does not apply to a query as a whole. Whenever FOR SYSTEM_TIME is missing, FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP is implied.
            • SQL Server has FOR SYSTEM_TIME ALL
            • DB2 supports FOR SYSTEM_TIME for views, if these views use system-versioned tables and do not use FOR SYSTEM_TIME inside.
            • DB2 has a session setting like SET CURRENT TEMPORAL SYSTEM_TIME = current timestamp – 1 MONTH
            serg Sergei Golubchik added a comment - Assorted notes: SQL Standard only has FOR SYSTEM_TIME with AS OF ...| FROM ... TO ...| BETWEEN ... AND ... and it can only directly follow a table name in the FROM clause. Does not apply to a view, does not apply to a query as a whole. Whenever FOR SYSTEM_TIME is missing, FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP is implied. SQL Server has FOR SYSTEM_TIME ALL DB2 supports FOR SYSTEM_TIME for views, if these views use system-versioned tables and do not use FOR SYSTEM_TIME inside. DB2 has a session setting like SET CURRENT TEMPORAL SYSTEM_TIME = current timestamp – 1 MONTH

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.