MySQL Forums
Forum List  »  Partitioning

Error 1032 - Can't find record in table
Posted by: Detlev Jaeger
Date: August 09, 2006 09:27AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 1032 - Can't find record in table
20130
August 09, 2006 09:27AM
5681
September 13, 2006 03:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.