Comment 4 for bug 1099836

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

Indeed, MariaDB fixed this "bug" in 5.5.28:

https://kb.askmonty.org/en/mariadb-5528-changelog/ : "Added warnings for duplicate key errors when using INSERT IGNORE"

I say "bug" because although http://dev.mysql.com/doc/refman/5.5/en/insert.html says "If you use the IGNORE keyword, errors that occur while executing the http://dev.mysql.com/doc/refman/5.5/en/insert.html statement are treated as warnings instead.", even in MySQL 5.5.29 that is not actually the case.

So is it a MySQL or documentation bug? I checked 5.0.96 and it does not generate a warning. Yet, http://dev.mysql.com/doc/refman/4.1/en/insert.html says it's treated as a warning.

So I think we have a clear case here were historical precedence of how things actually working has become the rule, despite equally historical documentation to the contrary.

In any case, Brian is going to try making the tool simply ignore "Duplicate entry" warnings altogether because that's what we intend to do by using INSERT IGNORE. So far, I can't think of why ignoring this warning would cause any problems.