Detlev,
It is possible that mysql is interpreting adr-0 as a
arithmetic operation, why don't you try quoting the
table name to prevent mysql trying to interpret it as
anything...
insert into `adr-0` values ('TestAdr','1') on
duplicate key update qty =
qty +1;
regards,
Enrique.
--- Detlev Jaeger <[EMAIL PROTECTED]> wrote:
> 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]
>
>
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
--------------------------------------
http://www.savetheinternet.com/
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
