INSERT IGNORE BUG?

[Ed Pauley II]

I am importing a file into a table in which I want it to ignore 
duplicate rows. When I specify --ignore (this also happens if I do a 
SELECT IGNORE INTO from the client also) I get a duplicate key error. If 
I run the command again it skips the first such instance of a duplicate 
key and gives me an error (and exits) for the next instance of a 
duplicate key. If I run the command over and over it finally goes 
through the whole file. Then the fun starts over. The primary key is on 
9 columns but the index shown in the error only has 6 of the columns 
listed. Is this a bug?

I am running ver. 5.0.27 on Linux.
--
Ed Pauley II
[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]