Bug #12842 DROP TABLE of temporary table causes RBR to stop.

• Submitted: 26 Aug 2005 19:21
• Modified: 31 Aug 2005 11:49
• Reporter: Jonathan Miller
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Version: 5.0-wl1012
• OS: Linux (Linux)
• Assigned to: Elliot Murphy
• CPU Architecture: Any

[26 Aug 2005 19:21] Jonathan Miller

Description:
Consider the following test:
-- source include/master-slave.inc
CREATE TEMPORARY TABLE test.t1 (a INT);
DROP TABLE test.t1;

result:
050826 22:07:27 [ERROR] Slave: Error 'Unknown table 't1'' on query. Default database: 'test'. Query: 'DROP TABLE test.t1', Error_code: 1051
050826 22:07:27 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 102

How to repeat:
see above

[31 Aug 2005 11:49] Jonathan Miller

Duplicate of 12415