Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33286

Ones should be able to see in information_schema.tables if a table is encrypted

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6
    • None
    • Encryption
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.