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

COPY alter algorithm is not supported for some CONNECT tables

Details

    Description

      According to the documentation, COPY algorithm is supposed to be universal for all engines, even though slow. CONNECT engine (with some table types) appears to be an exception.

      INSTALL SONAME 'ha_connect';
      		 
       
      		 
      CREATE TABLE t (fname VARCHAR(8) NOT NULL, ftype VARCHAR(8) NOT NULL) ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='tf';
      		 
      ALTER TABLE t FILE_NAME='tf2', ALGORITHM=COPY;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;
      		 
      UNINSTALL SONAME 'ha_connect';

      10.4 ff3d4395

      		 
      mysqltest: At line 4: query 'ALTER TABLE t FILE_NAME='tf2', ALGORITHM=COPY' failed: 1105: Operation denied. Table data would be modified.

      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
          Affects Version/s 10.7 [ 24805 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.8 [ 26121 ]
          serg Sergei Golubchik added a comment -

          I'd suggest to use HA_NO_COPY_ON_ALTER here, but it'd require a non-trivial refactoring in mysql_alter_table()

          serg Sergei Golubchik added a comment - I'd suggest to use HA_NO_COPY_ON_ALTER here, but it'd require a non-trivial refactoring in mysql_alter_table()
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.9 [ 26905 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.10 [ 27530 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 11.0 [ 28320 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.4 [ 22408 ]
          danblack Daniel Black made changes -
          Assignee Andrew Hutchings [ JIRAUSER52179 ]

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.