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

  1. Bug #1662059
  2. Comment #1

Comment 1 for bug 1662059

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;