• Venkatesh Duggirala's avatar
    Bug #20439913 CREATE TABLE DB.TABLE LIKE TMPTABLE IS BINLOGGED INCORRECTLY - BREAKS A SLAVE · 151b8ec4
    Venkatesh Duggirala authored
    Analysis:
    In row based replication, Master does not send temp table information
    to Slave. If there are any DDLs that involves in regular table that needs
    to be sent to Slave and a temp tables (which will not be available at Slave),
    the Master rewrites the query replacing temp table with it's defintion.
    Eg: create table regular_table like temptable.
    In rewrite logic, server is ignoring the database of regular table
    which can cause problems mentioned in this bug.
    
    Fix: dont ignore database information (if available) while
    rewriting the query
    151b8ec4
rpl_tmp_table_and_DDL.test 4.93 KB