Hello,
I'm curently testing partitioning with mysql 5.1.11 on linux (.rpm from
mysql.com site).
Table Structure:
CREATE TABLE `adr-0` (
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 inserting data:
insert into adr-0 values ('TestAdr','1') on duplicate key update qty =
qty +1;
This works fine until "on duplicate key " triggers. Then I receive the
error message:
"1032: Can't find record in adr-0"
When I'm doing the same on a non-partitioned table, everything work as
expected.
I haven't found any limitations of the partitioning in the manual, which
could be the reason.
Is this a bug or a feature ?
Thanks in advance for any help !
Detlev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
