Hi Vladislav, > So, IGNORE causes INSERT not to raise any error on any error :) Actually, I > don't really like this behavior since it swallows errors. Warnings are > usually not properly handled by error-handling code in most APIs.
Thanks for your insight. You're right, I guess it is up to the user to assess whether they want to make wise use of the IGNORE clause. Other databases have a much more powerful MERGE statement, to handle all similar cases: MERGE INTO table USING (...) ON (...) WHEN NOT MATCHED THEN INSERT (...) A bit more verbose, yet very precise. For jOOQ, I'm sure it makes sense to support MySQL's IGNORE clause, for those rare cases where this makes sense... Do you think, jOOQ should propagate these "warnings"? As I understand it, they can be safely ignored...? Cheers Lukas
