diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-page_compression_tables.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-page_compression_tables.result | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-page_compression_tables.result b/mysql-test/suite/innodb/r/innodb-page_compression_tables.result index 33b36428040..439f409ea59 100644 --- a/mysql-test/suite/innodb/r/innodb-page_compression_tables.result +++ b/mysql-test/suite/innodb/r/innodb-page_compression_tables.result @@ -88,8 +88,12 @@ select count(*) from innodb_dynamic where c1 < 1500000; count(*) 5000 set global innodb_compression_algorithm = 0; -alter table innodb_compact engine=innodb page_compressed=DEFAULT; -alter table innodb_dynamic engine=innodb page_compressed=DEFAULT; +alter table innodb_compact page_compressed=DEFAULT, algorithm=instant; +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Changing table options requires the table to be rebuilt. Try ALGORITHM=INPLACE +alter table innodb_compact page_compressed=DEFAULT; +alter table innodb_dynamic page_compressed=DEFAULT, algorithm=instant; +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Changing table options requires the table to be rebuilt. Try ALGORITHM=INPLACE +alter table innodb_dynamic page_compressed=DEFAULT; show create table innodb_compact; Table Create Table innodb_compact CREATE TABLE `innodb_compact` ( |