Unable to add compression columns to a partitioned table via 'ALTER TABLE'

Bug #1671492 reported by Yura Sorokin on 2017-03-09
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.6
Fix Released
High
Yura Sorokin
5.7
Fix Released
High
Yura Sorokin

Bug Description

The following SQL fragment reports
1478: Table storage engine 'partition' does not support the create option 'COMPRESSED COLUMNS'
at 'ALTER TABLE'

CREATE TABLE t1 (
  id BIGINT UNSIGNED NOT NULL,
  a VARCHAR(250) DEFAULT NULL
) ENGINE=InnoDB
PARTITION BY RANGE (id) (
 PARTITION p1 VALUES LESS THAN (100) ENGINE = InnoDB,
 PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = InnoDB
);
ALTER TABLE t1 MODIFY a VARCHAR(250) COLUMN_FORMAT COMPRESSED;

Yura Sorokin (yura-sorokin) wrote :

The issue affects mostly 5.6 where the default partition engine is ha_partition.
It is not a problem with 5.7 native partitioning engine (ha_innopart).
However, 5.7 is still affected as it still can use old partitioned tables (remaining after upgrade, for instance).

summary: - Unable to add compression columns to a partitioned table via "ALTER
- TABLE"
+ Unable to add compression columns to a partitioned table via 'ALTER
+ TABLE'

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1074

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers