Column Compression Extensions for 5.7
https:/
Add support for compressed JSON columns.
Add support for indexes on virtual columns based on compressed fields:
- Purge threads now also need to have access to prebuilt object.
Add support for COMPRESSED attribute in STORED generated columns.
It should be possible to make generated columns compressed with optional compression dictionary. Please, notice that this makes sense only for STORED generated columns, for VIRTUAL ones the ER_UNSUPPORTED_
New generated column definition syntax:
col_name data_type [GENERATED ALWAYS] AS (expression)
[VIRTUAL | STORED] [UNIQUE [KEY]] [COMMENT comment]
[[NOT] NULL] [[PRIMARY] KEY]
[COLUMN_FORMAT {DEFAULT|
The new syntax is allowed in both 'CREATE TABLE' and 'ALTER TABLE' statements. The latter can also be used to apply/remove COMPRESSED attribute to/from an existing STORED generated column.
For instance
ALTER TABLE t MODIFY g BLOB GENERATED ALWAYS AS (a) STORED COLUMN_FORMAT COMPRESSED
or
ALTER TABLE t MODIFY g BLOB GENERATED ALWAYS AS (a) STORED COLUMN_FORMAT DEFAULT
Blueprint information
- Status:
- Complete
- Approver:
- Laurynas Biveinis
- Priority:
- High
- Drafter:
- Yura Sorokin
- Direction:
- Approved
- Assignee:
- Yura Sorokin
- Definition:
- Approved
- Series goal:
- Accepted for 5.7
- Implementation:
- Implemented
- Milestone target:
- 5.7.17-11
- Started by
- Yura Sorokin
- Completed by
- Yura Sorokin
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.