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

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.3 [ 22126 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.3.1-1 [ 164 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels 10.3-beta
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link PT-56 [ 62148 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.3.1-1 [ 164 ] 10.3.1-1, 10.3.1-2 [ 164, 174 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2 [ 164, 174 ] 10.3.1-1, 10.3.1-2, 10.3.3-1 [ 164, 174, 200 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2, 10.3.3-1 [ 164, 174, 200 ] 10.3.1-1, 10.3.1-2 [ 164, 174 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2 [ 164, 174 ] 10.3.1-1, 10.3.1-2, 10.3.3-2 [ 164, 174, 208 ]
            serg Sergei Golubchik made changes -
            marko Marko Mäkelä made changes -
            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
            serg Sergei Golubchik made changes -
            Component/s System-versioned tables [ 14303 ]
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2, 10.3.3-2 [ 164, 174, 208 ] 10.3.1-1, 10.3.1-2 [ 164, 174 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.3.1-1, 10.3.1-2 [ 164, 174 ] 10.3.1-1, 10.3.1-2, 10.1.30 [ 164, 174, 215 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3.4 [ 22904 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            marko Marko Mäkelä made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80929 ] MariaDB v4 [ 133265 ]

            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.