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

Unexpected ER_VERS_ENGINE_UNSUPPORTED upon dropping versioning on a partitioned table

Details

    Description

      10.3 1951e7f05ae7b6069eeffdfe8ab304fa3a18a85a

      		 
      MariaDB [test]> CREATE OR REPLACE TABLE t (a INT) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME (PARTITION p1 HISTORY, PARTITION pn CURRENT);
      		 
      Query OK, 0 rows affected (0.66 sec)
      		 
       
      		 
      MariaDB [test]> ALTER TABLE t DROP SYSTEM VERSIONING;
      		 
      ERROR 4109 (HY000): Transaction system versioning for `#sql-69b8_a` is not supported

      I can understand why ALTER has to fail, but the error code/message doesn't look right.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Elena Stepanova [ elenst ] Alexander Krizhanovsky [ krizhanovsky ]
          krizhanovsky Alexander Krizhanovsky made changes -
          Assignee Alexander Krizhanovsky [ krizhanovsky ] Eugene Kosov [ kevg ]
          midenok Aleksey Midenkov added a comment - - edited

          DROP SYSTEM VERSIONING rather should not fail but drop partitioning.

          DROP SYSTEM VERSIONING for partitioned table #465

          midenok Aleksey Midenkov added a comment - - edited DROP SYSTEM VERSIONING rather should not fail but drop partitioning. DROP SYSTEM VERSIONING for partitioned table #465
          serg Sergei Golubchik made changes -
          Fix Version/s 10.3.5 [ 22905 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 85368 ] MariaDB v4 [ 153715 ]

          People

            kevg Eugene Kosov (Inactive)
            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.