diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/instant_alter.test')
-rw-r--r-- | mysql-test/suite/innodb/t/instant_alter.test | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb/t/instant_alter.test b/mysql-test/suite/innodb/t/instant_alter.test index d2f96c2f6d5..4045ce282e8 100644 --- a/mysql-test/suite/innodb/t/instant_alter.test +++ b/mysql-test/suite/innodb/t/instant_alter.test @@ -6,8 +6,9 @@ let $format= `SELECT CASE WHEN @@GLOBAL.innodb_page_size>16384 THEN 'DYNAMIC' ELSE 'COMPRESSED' END`; -eval CREATE TABLE t(a INT UNIQUE)ENGINE=InnoDB ROW_FORMAT=$format; -INSERT INTO t VALUES(1); +CREATE TABLE t(a INT UNIQUE)ENGINE=InnoDB ROW_FORMAT=COMPACT; +eval ALTER TABLE t ADD e INT, ROW_FORMAT=$format; +INSERT INTO t SET a=1; SET @old_instant= (SELECT variable_value FROM information_schema.global_status WHERE variable_name = 'innodb_instant_alter_column'); @@ -26,6 +27,9 @@ SHOW CREATE TABLE t; SELECT variable_value-@old_instant instants FROM information_schema.global_status WHERE variable_name = 'innodb_instant_alter_column'; +SELECT variable_value-@old_instant instants +FROM information_schema.global_status +WHERE variable_name = 'innodb_instant_alter_column'; DROP TABLE t; connect analyze, localhost, root; |