/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/innodb/r/ |
H A D | instant_alter_limit.result | 12 ADD COLUMN b INT, ALGORITHM=INSTANT; 13 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 14 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT; 15 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT; 19 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT; 20 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT; 21 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 37 ALGORITHM=INSTANT;
|
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 70 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: innodb_instant_alter_column_allowed=never.… 71 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 72 ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: innodb_instant_alter_column_allowed=never. … 73 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 76 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/innodb/r/ |
H A D | instant_alter_limit.result | 12 ADD COLUMN b INT, ALGORITHM=INSTANT; 13 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 14 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT; 15 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT; 19 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT; 20 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT; 21 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 37 ALGORITHM=INSTANT;
|
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 70 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: innodb_instant_alter_column_allowed=never.… 71 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 72 ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: innodb_instant_alter_column_allowed=never. … 73 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 76 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/innodb/r/ |
H A D | instant_alter_limit.result | 12 ADD COLUMN b INT, ALGORITHM=INSTANT; 13 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 14 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT; 15 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT; 19 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT; 20 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT; 21 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 37 ALGORITHM=INSTANT;
|
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 70 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: innodb_instant_alter_column_allowed=never.… 71 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 72 ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: innodb_instant_alter_column_allowed=never. … 73 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 76 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/innodb/r/ |
H A D | instant_alter_limit.result | 12 ADD COLUMN b INT, ALGORITHM=INSTANT; 13 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 14 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT; 15 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT; 19 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT; 20 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT; 21 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 37 ALGORITHM=INSTANT;
|
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 70 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: innodb_instant_alter_column_allowed=never.… 71 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 72 ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: innodb_instant_alter_column_allowed=never. … 73 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 76 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
H A D | gis-alter_table_online.test | 17 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 22 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 27 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 32 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 41 ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 46 ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 51 ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 56 ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 66 ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 71 ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-varchar.test | 10 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 15 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 35 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 36 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 39 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 42 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 45 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 47 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 50 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
H A D | alter_rename_existing.test | 56 ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=INPLACE; 57 ALTER TABLE t1 ADD COLUMN d INT, ALGORITHM=COPY; 74 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=COPY; 91 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=COPY; 101 ALTER TABLE t1 ADD COLUMN e INT, ALGORITHM=INPLACE; 109 ALTER TABLE t1 TABLESPACE=innodb_system, ALGORITHM=INPLACE; 115 ALTER TABLE t1 TABLESPACE=s1, ALGORITHM=INPLACE; 125 --echo # Move t1 to a general tablespace using ALGORITHM=COPY. 127 ALTER TABLE t1 TABLESPACE=s1, ALGORITHM=COPY; 133 ALTER TABLE t1 TABLESPACE=innodb_system, ALGORITHM=COPY; [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/innodb/t/ |
H A D | innodb-alter-wl6554.test | 12 ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN pk pk VARCHAR(5); 17 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(7); 37 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 38 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(255); 41 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(6); 43 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(256); 44 --echo # ALGORITHM=COPY has more limitations with FOREIGN KEY. 47 ALTER TABLE t2 ALGORITHM=INPLACE, DROP FOREIGN KEY fk; 49 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(300); 52 ALTER TABLE t2 ALGORITHM=INPLACE, CHANGE COLUMN fk fk VARCHAR(99999); [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/rpl/t/ |
H A D | rpl_connection_compression_configuration.test | 7 # 3. ALGORITHM set to invalid values. 9 # 5. ALGORITHM and LEVEL not specified. 10 # 6. ALGORITHM specified and LEVEL not specified. 11 # 7. ALGORITHM not specified and LEVEL specified. 19 # 3. ALGORITHM changed to invalid values. 21 # 5. ALGORITHM and LEVEL not specified. 22 # 6. ALGORITHM specified and LEVEL not specified. 23 # 7. ALGORITHM not specified and LEVEL specified. 62 --echo # case 5: ALGORITHM = ZSTD, LEVEL = 9 69 --echo # case 6: ALGORITHM = ZSTD, LEVEL = 24 [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/innodb/r/ |
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 66 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 67 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 68 ERROR 0A000: ALGORITHM=NOCOPY is not supported for this operation. Try ALGORITHM=INPLACE 69 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 72 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/innodb/r/ |
H A D | alter_algorithm2.result | 48 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 50 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY 66 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE 67 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; 68 ERROR 0A000: ALGORITHM=NOCOPY is not supported for this operation. Try ALGORITHM=INPLACE 69 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; 72 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
|