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

usage of enforce_storage_engine may cause ALTER .. PARTITION BY statements to fail

    XMLWordPrintable

Details

    Description

      Test case:

      in my.cnf:

      enforce_storage_engine=innodb
      

      CREATE TABLE test_case (
      id int auto_increment primary key,
      testinfo text) engine=innodb;
       
      ALTER TABLE `test`.`test_case` ENGINE = InnoDB PARTITION BY HASH(id);
      

      Fails with: unknown engine 'partition'

      Attachments

        Activity

          People

            serg Sergei Golubchik
            tanj Guillaume Lefranc
            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.