diff options
author | Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com> | 2016-04-22 10:25:16 +0530 |
---|---|---|
committer | Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com> | 2016-04-22 10:25:16 +0530 |
commit | 3b6f9aac02b126db57fa3e3f1873713438d0a950 (patch) | |
tree | 44d9a28b92fea264e80ce422f6504261851037e0 /client | |
parent | fbf44eed3c69dc15047ac2d40c09dd0d16993fb0 (diff) | |
download | mariadb-git-3b6f9aac02b126db57fa3e3f1873713438d0a950.tar.gz |
BUG#23135731: INSERT WITH DUPLICATE KEY UPDATE REPORTS
INCORRECT ERROR.
Analysis
========
INSERT with DUPLICATE KEY UPDATE and REPLACE on a table
where foreign key constraint is defined fails with an
incorrect 'duplicate entry' error rather than foreign
key constraint violation error.
As part of the bug fix for BUG#22037930, a new flag
'HA_CHECK_FK_ERROR' was added while checking for non fatal
errors to manage FK errors based on the 'IGNORE' flag. For
INSERT with DUPLICATE KEY UPDATE and REPLACE queries, the
foreign key constraint violation error was marked as non-fatal,
even though IGNORE was not set. Hence it continued with the
duplicate key processing resulting in an incorrect error.
Fix:
===
Foreign key violation errors are treated as non fatal only when
the IGNORE is not set in the above mentioned queries. Hence reports
the appropriate foreign key violation error.
Diffstat (limited to 'client')
0 files changed, 0 insertions, 0 deletions