Re: Partitioning causes duplicate key error

[fz wsc]

The next table is OK:

CREATE TABLE `t1` (
`id` int(10) unsigned NOT NULL,
`p1` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
COLLATE utf8_general_ci
PARTITION BY LINEAR KEY(`p1`)
PARTITIONS 4;


But I want id "auto_increment and unique", then error occurs:


mysql> CREATE TABLE `t1` (
-> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-> `p1` varchar(50) NOT NULL
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
-> COLLATE utf8_general_ci
-> PARTITION BY LINEAR KEY(`p1`)
-> PARTITIONS 4;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto colum
n and it must be defined as a key