• Alfranio Correia's avatar
    BUG#35583 mysqlbinlog replay fails with ERROR 1146 when temp tables are used · 23d032c3
    Alfranio Correia authored
          
    When using CREATE TEMPORARY TABLE LIKE to create a temporary table, 
    or using TRUNCATE to delete all rows of a temporary table, they 
    did not set the tmp_table_used flag, and cause the omission of
    "SET @@session.pseudo_thread_id" when dumping binlog with mysqlbinlog,
    and cause error when replay the statements.
          
    This patch fixed the problem by setting tmp_table_used in these two
    cases. (Done by He Zhenxing 2009-01-12)
    
    
    mysql-test/suite/binlog/r/binlog_tmp_table.result:
      Add test case for BUG#35583
    mysql-test/suite/binlog/t/binlog_tmp_table.test:
      Add test case for BUG#35583
    sql/sql_delete.cc:
      set thd->tmp_table_used when truncate temporary table
    sql/sql_table.cc:
      set thd->tmp_table_used when using create like to create temporary tables
    23d032c3
sql_delete.cc 31.9 KB