# # MDEV-11757 KEY_BLOCK_SIZE strangeness when UNCOMPRESSing COMPRESSed InnoDB tables # source include/have_innodb.inc; --disable_query_log SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed; SET GLOBAL innodb_read_only_compressed=OFF; --enable_query_log create table t1 ( id1 bigint(20) not null, id2 bigint(20) not null, primary key (id1), unique key id2 (id2) ) engine=innodb row_format=compressed key_block_size=8; show create table t1; SET innodb_strict_mode=ON; --error ER_ILLEGAL_HA_CREATE_OPTION alter table t1 row_format=dynamic; SET innodb_strict_mode=OFF; alter table t1 row_format=dynamic; show create table t1; SET innodb_strict_mode=ON; --disable_query_log SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed; --enable_query_log alter table t1 key_block_size=0; show create table t1; alter table t1 drop primary key, add primary key (id1), drop key id2, add unique (id2); show create table t1; drop table t1;