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

wrong error message adding AS ROW START to versioned table

    XMLWordPrintable

Details

    Description

      create table t1 (a int,
      		 
      rs timestamp(6) as row start,
      		 
      re timestamp(6) as row end,
      		 
      period for system_time(rs,re)) with system versioning;
      		 
      alter table t1 add column rss timestamp(6) as row start;


      mysqltest: At line 6: query 'alter table t1 add column rss timestamp(6) as row start' failed: 4124: Table `t1` is not system-versioned

      Attachments

        Issue Links

          blocks

          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
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19654 Table `sbtest1` is not system-versioned error with system versioned table while adding row start column

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25172 Wrong error message for ADD COLUMN .. AS ROW START

          • Major - Major loss of function.
          • Closed

          Activity

            People

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