CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`a` blob /*!50633 COLUMN_FORMAT COMPRESSED */,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (id)
(PARTITION pa100 VALUES LESS THAN (100) ENGINE = MyISAM,
PARTITION paMax VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */
With PS 5.7:
master [localhost] {msandbox} (dbtest) > alter table t1 compression='zlib';
ERROR 1478 (HY000): Table storage engine 'partition' does not support the create option 'COMPRESSED COLUMNS'
CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`a` blob /*!50633 COLUMN_FORMAT COMPRESSED */,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (id)
(PARTITION pa100 VALUES LESS THAN (100) ENGINE = MyISAM,
PARTITION paMax VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */
With PS 5.7:
master [localhost] {msandbox} (dbtest) > alter table t1 compression='zlib';
ERROR 1478 (HY000): Table storage engine 'partition' does not support the create option 'COMPRESSED COLUMNS'