Bug #64596 duplicate record error
Submitted: 9 Mar 2012 0:41 Modified: 8 Aug 2012 15:20
Reporter: Miran Cvenkel Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1.59-community-log OS:Any
Assigned to: CPU Architecture:Any

[9 Mar 2012 0:41] Miran Cvenkel
Description:
Field1 is here default null and is filled by trigger on before insert

insert ignore into table1 (primary_key_field,field1)
select primary_key_field,field1 from table2

In case there are in table2 data like
primary_key_field
1
1

you would get: duplicate record (sory forgot exact error) error

allso you would get exactly same report, if originating from trigger on field1

If possible, that additional information (on origin of error) should be added
to error text.

How to repeat:
see above
[8 Jul 2012 15:20] Valeriy Kravchuk
I am not sure I understand the problem you described. Please, send complete, repeatable test case that demonstrate the problem.
[9 Aug 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".