The following list indicates limitations on the use of
TEMPORARYtable can only be of type
Temporary tables are not supported for MySQL Cluster.
You cannot refer to a
TEMPORARYtable more than once in the same query. For example, the following does not work:
SELECT * FROM temp_table, temp_table AS t2;ERROR 1137: Can't reopen table: 'temp_table'
This error also occurs if you refer to a temporary table multiple times in a stored function under different aliases, even if the references occur in different statements within the function.
SHOW TABLESstatement does not list
You cannot use
RENAMEto rename a
TEMPORARYtable. However, you can use
ALTER TABLE orig_name RENAME new_name;
There are known issues in using temporary tables with replication. See Section 18.4.1, “Replication Features and Issues”, for more information.
Temporary tables created outside stored functions and referred to across multiple calling and callee functions might result in this error:
ERROR 1137: Can't reopen table: '