• 's avatar
    Bug#55478 Row events wrongly apply on the temporary table of the same name · aa235b1b
    authored
    Rows events were applied wrongly on the temporary table with the same name.
    But rows events are generated only for base tables. As temporary
    table's data never be binlogged on row mode. Normally, base table of the
    same name cannot be updated if a temporary table has the same name.
    But there are two cases which can generate rows events on 
    the base table of same name.
          
    Case1: 'CREATE TABLE ... SELECT' statement.
    In mixed format, it will generate rows events if it is unsafe.
          
    Case2: Drop a transactional temporary table in a transaction
           (happens only on 5.5+).
    BEGIN;
    DROP TEMPORARY TABLE t1;       # t1 is a InnoDB table
    INSERT INTO t1 VALUES(rand()); # t1 is a MyISAM table
    COMMIT;
    'DROP TEMPORARY TABLE' will be put in the transaction cache and
    binlogged after the rows events generated by the 'INSERT' statement.
          
    After this patch, slave opens only base table when applying a rows event.
    aa235b1b
rpl_temp_table_mix_row.test 6.08 KB