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

Default TIMESTAMP clause for SELECT from versioned

Details

    Description

      Currently when there is no unit specifier in AS OF query like:

      select * from t1 for system_time as of @p1;

      it will do some heuristics to detect whether it should treat @p1 is trx_id or timestamp.

      Such semantic complexity should be removed in favour of default TIMESTAMP because:

      1. rare practical use and doubtful advantage;
      2. it conflicts with MDEV-16226.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-16226 TRX_ID-based System Versioning refactoring

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15408 Confusing error message upon ER_VERS_FIELD_WRONG_TYPE while omitting UNSIGNED in BIGINT

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16094 Crash when using AS OF with a stored function

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16100 FOR SYSTEM_TIME erroneously resolves string user variables as transaction IDs

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		2h 11m 1
            Aleksey Midenkov made transition -
            In Progress Stalled
            		3d 6h 50m 1
            Aleksey Midenkov made transition -
            Stalled Closed
            		3d 15h 54m 1
            Aleksey Midenkov made transition -
            Closed Stalled
            		98d 20m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            		10d 2h 20m 4
            Aleksey Midenkov made transition -
            In Review Stalled
            		382d 18h 43m 4
            Aleksey Midenkov made transition -
            Stalled In Progress
            		6d 5h 36m 5
            Aleksey Midenkov made transition -
            In Progress Closed
            		2d 21h 1

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.