Unable to add compression columns to a partitioned table via 'ALTER TABLE'
Bug #1671492 reported by
Yura Sorokin
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;
Revision history for this message
| Yura Sorokin (yura-sorokin) wrote | #1 |
| 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' |
Revision history for this message
| Yura Sorokin (yura-sorokin) wrote | #2 |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
To post a comment you must log in.
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).