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

Wrong error code/message 1478: 'Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID'

    XMLWordPrintable

Details

    Description

      ALTER in following test case produces an unexpected error message/code:

      --source include/have_innodb.inc
      		 
      --source suite/encryption/include/have_file_key_management_plugin.inc
      		 
       
      		 
      CREATE TABLE t1 (i INT) ENGINE=InnoDB ENCRYPTED=YES;
      		 
      # Here should be --error <error code>
      		 
      ALTER TABLE t1 ENCRYPTION_KEY_ID = 9;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;


      mysqltest: At line 5: query 'ALTER TABLE t1 ENCRYPTION_KEY_ID = 9' failed: 1478: Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID'

      The change was introduced in 10.1.29 by this commit:

      commit 88edb1b3edcea0dad82659ca6622448e535a3fa6
      		 
      Author: Marko Mäkelä <marko.makela@mariadb.com>
      		 
      Date:   Mon Oct 30 18:47:43 2017 +0200
      		 
       
      		 
          MDEV-14219 Allow online table rebuild when encryption or compression parameters change

      Judging by test result modifications in the commit, it was intentional. However, it is really wrong and misleading, the table option is obviously supported, it's just the key value that's wrong.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14219 Allow online table rebuild when encryption or compression parameters change

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12884 Bad error message upon ALTER TABLE with wrong ROW_FORMAT

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              vlad.lesin Vladislav Lesin
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.