• dlenev@mysql.com's avatar
    Fix for bug#13479 "REPLACE activates UPDATE trigger, not the DELETE and · 59d20e26
    dlenev@mysql.com authored
    INSERT triggers".
    
    In cases when REPLACE was internally executed via update and table had
    on update (on delete) triggers defined we exposed the fact that such
    optimization used by callng on update (not calling on delete) triggers.
    Such behavior contradicts our documentation which describes REPLACE as
    INSERT with optional DELETE.
    
    This fix just disables this optimization for tables with on delete triggers.
    The optimization is still applied for tables which have on update but have
    no on delete triggers, we just don't invoke on update triggers in this case
    and thus don't expose information about optimization to user.
    
    Also added test coverage for values returned by ROW_COUNT() function (and
    thus for values returned by mysql_affected_rows()) for various forms of
    INSERT.
    59d20e26
trigger.result 32.1 KB