Changing a column from uncompressed to compressed for JSON crashes the server
Bug #1704163 reported by
Alexander Rubin
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
|
Unassigned |
Bug Description
Percona server 5.7 includes the compression option https:/
When trying to change the field from uncompressed to compressed for JSON, and then select from the table, MySQL crashes.
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
select json_variables from tb_name limit 1\G
...
server crashes.
Error log shows:
2017-07-
tags: | added: column-compression |
To post a comment you must log in.
Please note: this only happens on alter table, not on initial table creation and insertion