Bug #80386 | alter table compression='none' rebuilds table each time with ENCRYPTION='N' | ||
---|---|---|---|
Submitted: | 16 Feb 2016 8:40 | Modified: | 31 Mar 2016 4:53 |
Reporter: | Shahriyar Rzayev | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S1 (Critical) |
Version: | 5.7.11 | OS: | CentOS (7) |
Assigned to: | CPU Architecture: | Any |
[16 Feb 2016 8:40]
Shahriyar Rzayev
[16 Feb 2016 9:45]
Shahriyar Rzayev
Same thing with alter tablespace: CREATE TABLE `sbtest5` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', `pad_c` int(11) GENERATED ALWAYS AS ((char_length(`pad`) + char_length(`c`))) STORED, PRIMARY KEY (`id`), KEY `k_1` (`k`) ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB AUTO_INCREMENT=1843230 DEFAULT CHARSET=latin1 mysql> alter table sbtest5 encryption='N'; Query OK, 1843229 rows affected (17,16 sec) Records: 1843229 Duplicates: 0 Warnings: 0 mysql> alter table sbtest5 tablespace=sbtest1; Query OK, 1843229 rows affected (15,62 sec) Records: 1843229 Duplicates: 0 Warnings: 0 mysql> alter table sbtest5 tablespace=sbtest1; Query OK, 1843229 rows affected (15,59 sec) Records: 1843229 Duplicates: 0 Warnings: 0
[17 Feb 2016 11:24]
MySQL Verification Team
Hello Shahriyar, Thank you for the report and test case. Thanks, Umesh
[31 Mar 2016 4:53]
Erlend Dahl
[23 Mar 2016 7:09] Daniel T Price Fixed as of the upcoming 5.7.13, 5.8.0 release, and here's the changelog entry: Online DDL operations like ALTER TABLE ... ADD INDEX were not permitted for tables created with the ENCRYPTION attribute. (Under the heading of Bug#22897921)