diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/alter_algorithm2.test')
-rw-r--r-- | mysql-test/suite/innodb/t/alter_algorithm2.test | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb/t/alter_algorithm2.test b/mysql-test/suite/innodb/t/alter_algorithm2.test index cf538e30196..cdece2398f0 100644 --- a/mysql-test/suite/innodb/t/alter_algorithm2.test +++ b/mysql-test/suite/innodb/t/alter_algorithm2.test @@ -45,15 +45,19 @@ DROP TABLE t1; DROP PROCEDURE p1; DROP PROCEDURE p2; +SET @save_allowed= @@GLOBAL.innodb_instant_alter_column_allowed; +SET GLOBAL innodb_instant_alter_column_allowed=never; + CREATE TABLE t1(id INT PRIMARY KEY, col1 INT UNSIGNED NOT NULL UNIQUE)ENGINE=InnoDB; INSERT INTO t1 VALUES(1,1),(2,2),(3,3); SET ALTER_ALGORITHM=INSTANT; ---error ER_ALTER_OPERATION_NOT_SUPPORTED +--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1 DROP COLUMN col1; ---error ER_ALTER_OPERATION_NOT_SUPPORTED +--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY; ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT; ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT; DROP TABLE t1; --disable_info +SET GLOBAL innodb_instant_alter_column_allowed=@save_allowed; |