Hi --
Have you tried this same query with MyISAM tables?
If your query works with MyISAM, and not with ndbcluster,
then you're probably experiencing what I described in this post:
http://lists.mysql.com/cluster/1856
Which is a bug:
http://bugs.mysql.com/bug.php?id=9675
Supposed to be fixed in 4.1.12.
-- Jim Hoadley
Sr Soft Eng
Dealer Fusion, Inc
--- philong.nguyen@stripped wrote:
> Hello,
>
> I am running MySQL Cluster 4.1.8 and I'm trying to do the following
> insert and it keeps complaining about duplicate entry '62.6.88.11-1/0.5'
>
> INSERT INTO tab1 SELECT * FROM tab2;
>
> Here is the definiton of tab1.
> mysql> describe tab1;
> +------------------+--------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +------------------+--------------+------+-----+---------+-------+
> | DeviceIP | varchar(15) | | PRI | | |
> | InterfaceName | varchar(255) | | PRI | | |
> | ServiceSpeedConf | varchar(64) | YES | | NULL | |
> | ServiceID | varchar(160) | YES | | NULL | |
> | CustomerID | varchar(16) | | | | |
> | NumConns | int(11) | YES | | NULL | |
> +------------------+--------------+------+-----+---------+-------+
>
> An extract of tab2
> ...
>
> 62.6.88.11 | 1/0.5 | | | 88142
> | 1 |
> | 62.6.88.11 | 1/0.65 | | | 88142
> | 1 |
> | 62.6.88.11 | 1/0.7 | | | 88142
> | 1 |
> | 62.6.88.11 | 1/0.59 | | | 88142
> | 1 |
>
> ...
>
>
> There are NO keys defined in tab2.
>
> Can someone tell me why it's complaining about duplicate key since the
> combination of "DeviceIP + InterfaceName" is different. This looks like
> it does not consider what is behind the "." in the InterfaceName field.
>
> Thanks for your help,
>
> Philong
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
