• guilhem@gbichot3.local's avatar
    Fix for BUG#25507 "multi-row insert delayed + auto increment causes · 8b1609a6
    guilhem@gbichot3.local authored
    duplicate key entries on slave" (two concurrrent connections doing
    multi-row INSERT DELAYED to insert into an auto_increment column,
    caused replication slave to stop with "duplicate key error" (and
    binlog was wrong)), and BUG#26116 "If multi-row INSERT
    DELAYED has errors, statement-based binlogging breaks" (the binlog
    was not accounting for all rows inserted, or slave could stop).
    The fix is that: if (statement-based) binlogging is on, a multi-row
    INSERT DELAYED is silently converted to a non-delayed INSERT.
    Note: it is not possible to test BUG#25507 in 5.0 (requires mysqlslap),
    so it is tested only in the changeset for 5.1. However, BUG#26116
    is tested here, and the fix for BUG#25507 is the same code change.
    8b1609a6
rpl_insert_delayed.result 752 Bytes