Bug #18487 UPDATE IGNORE not supported for unique constraint violation of non-primary key
Submitted: 24 Mar 2006 15:08 Modified: 6 Dec 2006 4:23
Reporter: Martin Skold Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version: OS:
Assigned to: Martin Skold CPU Architecture:Any

[24 Mar 2006 15:08] Martin Skold
Description:
In an UPDATE IGNORE statement
unique contraint violations are not
ignored if on non-primary key.

How to repeat:
Do an UPDATE IGNORE
that violates uniqueness constraint of
non-primary key.

Suggested fix:
Should be fixed along the line of fix for
Bug #17431  	INSERT IGNORE INTO returns failed: 1296: err 4350 'Transaction already aborted'
, but with extra checks if the update modified a row with the same value
for the possibly conflicting key value.
[30 Nov 2006 15:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/16227

ChangeSet@1.2333, 2006-11-30 16:19:55+01:00, mskold@mysql.com +1 -0
  bug#18487  UPDATE IGNORE not supported for unique constraint violation of non-primary key: updated test result
[30 Nov 2006 16:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/16230

ChangeSet@1.2286, 2006-11-30 17:22:04+01:00, mskold@mysql.com +1 -0
  bug#18487  UPDATE IGNORE not supported for unique constraint violation of non-primary key: handle INSERT ... ON DUPLICATE KEY UPDATE
[30 Nov 2006 21:52] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/16257

ChangeSet@1.2287, 2006-11-30 22:52:23+01:00, mskold@mysql.com +2 -0
  bug#18487  UPDATE IGNORE not supported for unique constraint violation of non-primary key: only check pk if it is updated
[30 Nov 2006 22:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/16258

ChangeSet@1.2336, 2006-11-30 23:10:11+01:00, mskold@mysql.com +2 -0
  bug#18487  UPDATE IGNORE not supported for unique constraint violation of non-primary key: only check pk if it is updated
[6 Dec 2006 4:23] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix for 5.0.32/5.1.14.