| 1 |
CREATE TABLE t1(a int PRIMARY KEY) COMPRESSION='zlib'; |
| 2 |
ERROR HY000: Compression failed with the following error : Punch hole not supported by the filesystem or the tablespace page size is not large enough. |
| 3 |
CREATE TABLE t1(a int PRIMARY KEY); |
| 4 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 5 |
# copy unzipped .ibd and .cfg |
| 6 |
ALTER TABLE t1 IMPORT TABLESPACE; |
| 7 |
ERROR HY000: Schema mismatch (Compression option does not match) |
| 8 |
# Manually remove tablespace files, since import failed and drop won't delete them. |
| 9 |
DROP TABLE t1; |