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:
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
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.