Comment 1 for bug 1631954

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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'