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

COPY alter algorithm is not supported for some CONNECT tables

    XMLWordPrintable

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

          People

            TheLinuxJedi Andrew Hutchings
            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.