Re: Partitioning causes duplicate key error

[fz wsc]

Maybe I'm also hitting this bug, hope 5.1.10 can be released ASAP.

mysql> CREATE TABLE `t1` (
-> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-> `p1` varchar(50) NOT NULL,
-> PRIMARY KEY (`id`,`p1`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1

-> COLLATE utf8_general_ci
-> PARTITION BY LINEAR KEY(`p1`)
-> PARTITIONS 4;
Query OK, 0 rows affected (0.20 sec)

mysql> insert into t1 values(NULL,'abc');
Query OK, 1 row affected (0.00 sec)

mysql> insert into t1 values(NULL,'abc');
ERROR 1022 (23000): Can't write; duplicate key in table 't1'
mysql>