12 messages in com.mysql.lists.mysqlRE: INSERT ... SELECT implies IGNORE ...
FromSent OnAttachments
kei...@tobacco.org07 Nov 2001 07:39 
Christopher Book07 Nov 2001 07:57 
Rick Emery07 Nov 2001 08:48 
Carsten H. Pedersen07 Nov 2001 09:04 
Paul DuBois07 Nov 2001 09:05 
Christopher Book07 Nov 2001 09:09 
Heikki Tuuri07 Nov 2001 09:34 
Keith C. Ivey07 Nov 2001 09:38 
Keith C. Ivey07 Nov 2001 09:43 
Christopher Book07 Nov 2001 10:36 
Keith C. Ivey07 Nov 2001 15:47 
Michael Widenius07 Nov 2001 19:02 
Subject:RE: INSERT ... SELECT implies IGNORE (bug?)
From:Michael Widenius (mon@mysql.com)
Date:11/07/2001 07:02:38 PM
List:com.mysql.lists.mysql

Hi!

"Heikki" == Heikki Tuuri <Heik@innobase.inet.fi> writes:

Heikki> Hi! Heikki> I think there is a bug in the MySQL manual. The default in

Heikki> INSERT INTO ... SELECT ...

Heikki> really is IGNORE. But I think this is not mentioned in the manual. I do
not Heikki> know either how one switches off IGNORE from this statement.

This was a bug in 3.23.

I have now changed for 4.0.1 that IGNORE is not enabled by default. I have also added a note about this change in the 'upgrading to 4.0' section in the manual.

Regards, Monty