• unknown's avatar
    Bug #26418: Slave out of sync after · fe593bf1
    unknown authored
     CREATE/DROP TEMPORARY TABLE + ROLLBACK on master
    
    The transaction ability of the storage engines of
    the tables on the replication master and the replication
    slave must generally be the same.
    When the storage engine type of the slave is 
    non-transactional then transactions on the master that 
    mix update of transactional and non-transactional tables
    should be avoided because they will cause inconsistency of
    the data between the master's transactional table and the
    slave's non-transactional table.
    
    The effect described by this bug is actually expected.
    A detailed test case is added (to be merged later to
    the updated rpl_ddl.test), as there was no coverage 
    by the existing tests. 
    Some code cleanup is also added by this change.
    
    
    mysql-test/r/rpl_innodb.result:
      Bug #26418: test case
    mysql-test/t/rpl_innodb.test:
      Bug #26418: test case
    sql/events.cc:
      Bug #26418: replace repeating code with a function call
    sql/sp.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_acl.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_class.cc:
      Bug #26418: remove dead code
    sql/sql_class.h:
      Bug #26418: remove dead code
    sql/sql_delete.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_parse.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_rename.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_tablespace.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_trigger.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_udf.cc:
      Bug #26418: replace repeating code with a function call
    sql/sql_view.cc:
      Bug #26418: replace repeating code with a function call
    fe593bf1
sql_trigger.cc 51.7 KB