Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.11, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
This fails:
===========
CREATE UNIQUE INDEX MyIndexName on MyTableName (
|
UserId ASC,
|
RepId ASC,
|
Field03,
|
Field04
|
);
|
|
|
"ERROR 1286 (42000): Unknown storage engine 'partition'"
|
|
This works:
============
ALTER TABLE MyTableName ADD UNIQUE MyIndexName (UserId ASC,
|
RepId ASC,
|
Field03,
|
Field04
|
);
|
|
Table definition:
|
|
CREATE TABLE `MyTableName` (
|
`Field01` bigint(20) NOT NULL,
|
`UserId` bigint(20) NOT NULL,
|
`RepId` bigint(20) NOT NULL,
|
`Field03` varchar(32) NOT NULL,
|
`Field04` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
PRIMARY KEY (`UserId`,`RepId`,`Field01`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
|
PARTITION BY HASH (`UserId`)
|
PARTITIONS 10
|