Bug #92760 Cannot alter InnoDB table to MyISAM if table definition has encryption='N' text
Submitted: 12 Oct 2018 7:09 Modified: 12 Oct 2018 7:35
Reporter: Ramesh Sivaraman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0, 5.7.23 OS:Any
Assigned to: CPU Architecture:Any

[12 Oct 2018 7:09] Ramesh Sivaraman
Description:
We cannot alter InnoDB table to MyISAM table if table definition has encryption='N' text.

8.0.12>CREATE TABLE t2 (   `id` int(11) NOT NULL AUTO_INCREMENT,   `k` int(11) NOT NULL DEFAULT '0',   `c` char(120) NOT NULL DEFAULT '',   `pad` char(60) NOT NULL DEFAULT '',   PRIMARY KEY (`id`),   KEY `k_1` (`k`) ) ENGINE=InnoDB encryption='N';
Query OK, 0 rows affected (0.72 sec)

8.0.12>
8.0.12>alter table t2  engine=MYISAM;                                                                                       ERROR 1031 (HY000): Table storage engine for '#sql-9e2_9' doesn't have this option
8.0.12>

This issue is not reproducible we remove the text "encryption='N'  " from the table creation statement.

How to repeat:
CREATE TABLE t2 (   `id` int(11) NOT NULL AUTO_INCREMENT,   `k` int(11) NOT NULL DEFAULT '0',   `c` char(120) NOT NULL DEFAULT '',   `pad` char(60) NOT NULL DEFAULT '',   PRIMARY KEY (`id`),   KEY `k_1` (`k`) ) ENGINE=InnoDB encryption='N';

alter table t2  engine=MYISAM;
[12 Oct 2018 7:35] MySQL Verification Team
Hello Ramesh,

Thank you for the report.
Observed this with 5.7.23.

regards,
Umesh