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

Strange ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN upon ALTER on versioning column

    XMLWordPrintable

Details

    Description

      create or replace table t1 (i int, j int as (i), s timestamp(6) as row start, e timestamp(6) as row end, period for system_time(s,e)) with system versioning;
       
      alter table t1 modify s timestamp(6) as row start;
      

      ALTER returns the error:

      MariaDB [test]> alter table t1 modify s timestamp(6) as row start;
      ERROR 1907 (HY000): This is not yet supported for generated columns
      

      This is strange, because ALTER doesn't even modify anything; and even more strange, because ALTER on the same table for a generated column not related to versioning works all right:

      MariaDB [test]> alter table t1 modify j int as (i);
      Query OK, 0 rows affected (0.00 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      

      It would be understandable if it said that ALTER is not supported for versioning columns (if that's indeed so), but the error as it is now is wrong.

      Attachments

        Issue Links

          Activity

            People

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