"Gordon" <[EMAIL PROTECTED]> wrote:
> Sorry for the repost, but I just realized that the index information for
> key 3 did not get copied into the 1st email.
This sounds very similar to the bug:
http://bugs.mysql.com/bug.php?id=2446
>
> -----Original Message-----
> From: Gordon [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 09, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: non unique index on MySQL 5.0
>
> I just installed MySQL 5.0 on my windows machine and was trying to load
> the output from a MySQLFront export from our 4.0.16 production system
>
> when I got the following error..
>
>
> C:\>mysql -u root mailprint < e:\mp20040205.sql
>
> ERROR 1062 at line 7893168: Duplicate entry 'Name-4928 N Brooklyn
> Kansas City' for key 3
>
>
> I'm not sure why I would get a "Duplicate entry" error on an index that
> was not defined as Unique.
>
>
> Have the rules for indexes changed somewhere between 4.0.16 and 5.0 ?
>
>
> Here is the table definition from the 4.0.16 machine.
>
> | product_order_features | CREATE TABLE `product_order_features` (
> `ordr_ID` int(11) unsigned NOT NULL default '0',
> `poft_Sub_Month` char(3) NOT NULL default '0',
> `poft_ID` tinyint(3) unsigned NOT NULL auto_increment,
> `poft_Sub_Item` char(1) NOT NULL default '0',
> `poft_Feature` varchar(40) NOT NULL default '',
> `poft_Value` text NOT NULL,
> `poft_Contents` text,
> `poft_Active` enum('Yes','No','Mail Sent','Deleted','PKOR','PK Hold')
> NOT NULL default 'Yes',
> `poft_Timestamp` timestamp(14) NOT NULL,
> `poft_Create` datetime NOT NULL default '0000-00-00 00:00:00',
> PRIMARY KEY (`ordr_ID`,`poft_Sub_Month`,`poft_Feature`,`poft_ID`),
> KEY `Feature_Value_IDX` (`poft_Feature`,`poft_Value`(20)),
> KEY `Feature_Contents_IDX` (`poft_Feature`,`poft_Contents`(20))
> ) TYPE=MyISAM |
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
