Bug #6196 INSERT IGNORE should return warnings
Submitted: 21 Oct 2004 12:44 Modified: 23 Jul 2014 1:52
Reporter: Carsten Pedersen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[21 Oct 2004 12:44] Carsten Pedersen
Description:
INSERT IGNORE should set an appropriate warning for each record that could not be added to the table (so that these may be found using SHOW WARNINGS).

How to repeat:
mysql> create table t (i int primary key not null);
Query OK, 0 rows affected (0.00 sec)

mysql> insert ignore into t values (1), (1), (1), (1);
Query OK, 0 rows affected (0.00 sec)
Records: 4  Duplicates: 4  Warnings: 0
[21 Oct 2004 13:51] Carsten Pedersen
There is of course an

insert into t values (1);

missing in between the two how-to-repeat statements
[1 Aug 2009 7:02] Sveta Smirnova
Thank you for the reasonable feature request.
[23 Jul 2014 1:52] Paul DuBois
Noted in 5.7.5 changelog.

The server failed to report warnings for INSERT IGNORE statements.