Error 1032 - Can't find record in table

[Detlev Jaeger]

hello,

I have posted the same question a few days ago into the "newbie" section but no one seems to know an answer. Now I have discovered this section of the forum and I hope, that someone can help me:


I have a problem with a very simple table when using partitioning in mysql 5.1.11 on SuSE Linux 10.0:

Table Information:

CREATE TABLE `test` (
Adr varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '',
Qty int(10) NOT NULL,
PRIMARY KEY (Adr),
)
ENGINE=MyISAM DEFAULT CHARSET=latin1
COLLATE=latin1_german1_ci
PARTITION BY KEY (Adr) PARTITIONS 10 ;

now i'm entering data into the table:

insert into `test` values ('TestAdr','1')
on duplicate key update Qty = Qty + 1;

this works fine until the "on duplicate key" triggers. When a duplicate key is found I get the error 1032 "can't find record in adr-0" instead of an increasing field qty.

I see no limitations in the partioning section of the mysql documentation which could cause this error. On a non-partitioned table it works fine under 5.1.11.

Is someone out there who knows if this is a bug or an unknown feature?

Thanks for any hint.

Detlev.