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

Add system versioning via modify column WITH SYSTEM VERSIONING

Details

    Description

      The WITH SYSTEM VERSIONING column option is intended to enable system versioning on a column level.

      With this column option, it is even possible use CREATE TABLE to create a system-versioned table that only provides system versioning for a single column:

      MariaDB [test]> CREATE TABLE accounts_col (
      		 
          ->    id SERIAL PRIMARY KEY,
      		 
          ->    name VARCHAR(255),
      		 
          ->    amount INT WITH SYSTEM VERSIONING
      		 
          -> );
      		 
      Query OK, 0 rows affected (0.021 sec)

      However, if you try to add the column option to a column in a non-system-versioned table, it raises an error message:

      MariaDB [test]> ALTER TABLE accounts_col
      		 
          ->    MODIFY name VARCHAR(255) WITH SYSTEM VERSIONING;
      		 
      ERROR 4124 (HY000): Table `accounts_col` is not system-versioned

      If this works for CREATE TABLE, shouldn't it also work for ALTER TABLE?

      To reproduce:

      CREATE TABLE accounts_col (
      		 
         id SERIAL PRIMARY KEY,
      		 
         name VARCHAR(255),
      		 
         amount INT
      		 
      );
      		 
       
      		 
      ALTER TABLE accounts_col
      		 
         MODIFY name VARCHAR(255) WITH SYSTEM VERSIONING;

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-12894 System-versioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-26934 ADD SYSTEM VERSIONING and modify column WITHOUT SYSTEM VERSIONING in single ALTER TABLE command

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenkov [ midenok ]
            midenok Aleksey Midenkov made changes -
            Component/s Data Definition - Alter Table [ 10114 ]
            Component/s Versioned Tables [ 14303 ]
            Component/s Data Definition - Alter Table [ 14927 ]
            Component/s Versioned Tables [ 15003 ]
            Key MENT-1357 MDEV-26993
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.6.4-1 [ 26058 ]
            Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
            midenok Aleksey Midenkov made changes -
            Affects Version/s 10.3 [ 22126 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            midenok Aleksey Midenkov made changes -
            Summary Error when adding system versioning for a single column to a non-system-versioned table Add system versioning via modify column WITH SYSTEM VERSIONING
            midenok Aleksey Midenkov added a comment -

            That didn't work by design. As a new feature would be nice to have it.

            midenok Aleksey Midenkov added a comment - That didn't work by design. As a new feature would be nice to have it.
            midenok Aleksey Midenkov made changes -
            midenok Aleksey Midenkov made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 126846 ] MariaDB v4 [ 131581 ]

            People

              midenok Aleksey Midenkov
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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