Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6
-
None
-
None
Description
Currently information_schema.tables does not contain encryption options in some cases.
This is needed to ensure that logical tools like mysqldump + mysqlimport will create the new tables encrypted if the original was encrypted.
(Unfortunately the mysqldump output will not be encrypted, but this is a separate issue).
Having the encryption option in information_schema.tables will also make it easier to quickly check which tables are encrypted and which are not.
Currently one will get the encryption option in CREATE_OPTIONS in the case of:
CREATE TABLE t1 (a int) engine=innodb encryption=yes;
However in the following case it will not be shown:
SET GLOBAL innodb_encrypt_tables = ON;
CREATE TABLE t1 (a int) engine=innodb;
Suggested fix:
- Add `encrypted`=yes last to CREATE_OPTIONS for encrypted tables if the option is not already there.