[MDEV-12080] usage of enforce_storage_engine may cause ALTER .. PARTITION BY statements to fail Created: 2017-02-17  Updated: 2020-12-01

Status: Confirmed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Partitioning
Affects Version/s: 10.1.21, 10.2.4
Fix Version/s: 10.2

Type: Bug Priority: Minor
Reporter: Guillaume Lefranc Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 1
Labels: None


 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'

 Comments   
Comment by Elena Stepanova [ 2017-02-21 ]

The important part here is the "ENGINE =" clause before the PARTITION clause.

Comment by Claudio Nanni [ 2019-05-30 ]

It fails also with other statements, after partitioning the table:

MariaDB [test]> CREATE INDEX idx1 ON test_case(testinfo);
 
ERROR 1286 (42000): Unknown storage engine 'partition'

Generated at Thu Feb 08 07:54:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.