• Guilhem Bichot's avatar
    Fix for BUG#31612 · f8670e2c
    Guilhem Bichot authored
    "Trigger fired multiple times leads to gaps in auto_increment sequence".
    The bug was that if a trigger fired multiple times inside a top
    statement (for example top-statement is a multi-row INSERT,
    and trigger is ON INSERT), and that trigger inserted into an auto_increment
    column, then gaps could be observed in the auto_increment sequence,
    even if there were no other users of the database (no concurrency).
    It was wrong usage of THD::auto_inc_intervals_in_cur_stmt_for_binlog.
    Note that the fix changes "class handler", I'll tell the Storage Engine API team.
    f8670e2c
trigger-trans.test 5.5 KB