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

System-versioned tables

    XMLWordPrintable

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

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 7.5d
                  7.5d

                  Git Integration

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