• unknown's avatar
    Bug#55478 Row events wrongly apply on the temporary table of the same name · ff9140b5
    unknown 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.
    ff9140b5
rpl_temp_table_mix_row.test 6.08 KB