• Nisha Gopalakrishnan's avatar
    BUG#23135731: INSERT WITH DUPLICATE KEY UPDATE REPORTS · 3b6f9aac
    Nisha Gopalakrishnan authored
                  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.
    3b6f9aac
insert.result 24.8 KB