It is impossible to drop COMPRESSION_DICTIONARY if server is killed during alter statement

[Shahriyar Rzayev]

Simple scenario:

Killing server while altering:

master [localhost] {msandbox} (dbtest) > alter table t1 modify `a` blob COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY `names`;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Result for table:

master [localhost] {msandbox} (dbtest) > show create table t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int(11) DEFAULT NULL,
  `a` blob /*!50631 COLUMN_FORMAT COMPRESSED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED COMMENT='New table comment'
1 row in set (0.00 sec)

Now if you want to drop dictionary:

master [localhost] {msandbox} (dbtest) > drop COMPRESSION_DICTIONARY `names`;
ERROR 1894 (HY000): Compression dictionary 'names' is in use

Result for scenario:
Abandoned compression_dictionary which can't be dropped.

If it is possible, the workaround must be provided.

[Shahriyar Rzayev (rzayev-sehriyar)]

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