[Compressed columns with dictionaries] 5.7 supports JSON column compression

Bug #1662059 reported by Laurynas Biveinis on 2017-02-06
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.5
Invalid
Undecided
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Triaged
High
Borys Belinsky

Bug Description

[In:/doc/percona-server/LATEST/flexibility/compressed_columns.html]

In 5.7, JSON is one of the supported data types for compressed columns with dictionaries, this must be stated.

Yura Sorokin (yura-sorokin) wrote :

Please, also add that 5.7 generated columns (both virtual and stored) can refer to compressed columns.

Moreover, we added syntax extension for stored generated columns, which allows to specify COLUMN_FORMAT COMPRESSED for them.

For instance,

CREATE TABLE t1(
  id INT,
  a BLOB,
  g BLOB GENERATED ALWAYS AS (a) STORED COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY numbers
) ENGINE=InnoDB;

Alexander Rubin (alikrubin75) wrote :

Changing a column from uncompressed to compressed for JSON crashes the server:

mysql> alter table tb_name modify json_variables JSON COLUMN_FORMAT compressed;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

2017-07-13T15:21:22.114757Z 3 [ERROR] [FATAL] InnoDB: unsupported compressed BLOB header format

tags: added: column-compression

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

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

Other bug subscribers