• Alfranio Correia's avatar
    BUG#53421 Part of transaction not written in binlog after deadlock, replication · ebde6f6d
    Alfranio Correia authored
    breaks
          
    When a "CREATE TEMPORARY TABLE SELECT * FROM" was executed the OPTION_KEEP_LOG was
    not set into the thd->variables.option_bits. For that reason, if the transaction
    had updated only transactional engines and was rolled back at the end (.e.g due to
    a deadlock) the changes were not written to the binary log, including the creation
    of the temporary table.
          
    To fix the problem, we have set the OPTION_KEEP_LOG into the
    thd->variables.option_bits when a "CREATE TEMPORARY TABLE
    SELECT * FROM" is executed.
    ebde6f6d
rpl_temp_temporary.test 8.7 KB