MySQL Bugs: #32212: Temporary table makes roll-forward impossible

Bug #32212	Temporary table makes roll-forward impossible
Submitted:	9 Nov 2007 8:48	Modified:	10 Oct 2008 6:17
Reporter:	Holger Thiel	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S4 (Feature request)
Version:	5.0.46	OS:	Linux (Cent OS 5)
Assigned to:		CPU Architecture:	Any
Tags:	recovery, roll-forward, temporary table

Description:
If you want to make a recovery with binlogs you cannot roll forward if you use temporary tables. 

If you take a backup while temporary tables are in use operation fail at recovery because sql-commandos refer to tables which are not existing.

There is no possibility to get information about the existence of temporary table if the server is no slave. On a slave there is the status "Slave_open_temp_tables". On normal server there is not such a variable,

How to repeat:
- 1. CREATE  TEMPORARY
- 2. BACKUP
- 3. Use temporary table with writing to binlog
- 4. Recover with Backup
- 5. Roll-Forward with Binlog

Suggested fix:
A status variable which shows the existence of temporary tables.

Thank you for the reasonable feature request.

This is a duplicate of bug #33574