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

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: