Percona Server moved to https://jira.percona.com/projects/PS

[Compressed columns with dictionaries] 5.7 supports JSON column compression

Bug #1662059 reported by Laurynas Biveinis
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.

Revision history for this message
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;

Revision history for this message
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

Laurynas Biveinis (laurynas-biveinis)
tags: added: column-compression
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.