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

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 10m
                10m

                Git Integration

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