B.1.7.3 TEMPORARY TABLE Problems

The following list indicates limitations on the use of TEMPORARY tables:

A TEMPORARY table can only be of type MEMORY, MyISAM, MERGE, or InnoDB.

Temporary tables are not supported for MySQL Cluster.
You cannot refer to a TEMPORARY table more than once in the same query. For example, the following does not work:
```
mysql> SELECT * FROM temp_table, temp_table AS t2;
ERROR 1137: Can't reopen table: 'temp_table'
```
The SHOW TABLES statement does not list TEMPORARY tables.
You cannot use RENAME to rename a TEMPORARY table. However, you can use ALTER TABLE instead:
```
mysql> ALTER TABLE orig_name RENAME new_name;
```
There are known issues in using temporary tables with replication. See 項5.4.1. 「レプリケーション機能と既知問題」, for more information.