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

Default TIMESTAMP clause for SELECT from versioned

    XMLWordPrintable

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

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3d 1h 10m
                  3d 1h 10m

                  Git Integration

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