|
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.
|
|