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

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34812 Storage engine set by enforce_storage_engine is not enforced for partioned tables

          • Major - Major loss of function.
          • Open

          Activity

            People

              serg Sergei Golubchik
              tanj Guillaume Lefranc
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.