• Alfranio Correia's avatar
    BUG#46864 Incorrect update of InnoDB table on slave when using trigger with myisam table · 354f5f7b
    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.
    
    mysql-test/extra/rpl_tests/rpl_mixing_engines.test:
      Enabled item 13.e which was disabled because of the bug fixed by the
      current and removed item 14 which was introduced by mistake.
    354f5f7b
log_event.cc 298 KB