• Alfranio Correia's avatar
    BUG#46864 Incorrect update of InnoDB table on slave when using trigger with myisam table · c21fbff3
    Alfranio Correia authored
    Slave does not correctly handle "expected errors" leading to inconsistencies
    between the mater and slave. Specifically, when a statement changes both
    transactional and non-transactional tables, the transactional changes are
    automatically rolled back on the master but the slave ignores the error and
    does not roll them back thus leading to inconsistencies.
          
    To fix the problem, we automatically roll back a statement that fails on
    the slave but note that the transaction is not rolled back unless a "rollback"
    command is in the relay log file.
    c21fbff3
rpl_mixing_engines.test 20.8 KB