MySQL Bugs: #10343: Can't reopen temporary table

Bug #10343	Can't reopen temporary table
Submitted:	3 May 2005 16:49	Modified:	3 May 2005 16:56
Reporter:	Jacek Becla	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.4-beta-standard	OS:	Linux (Redhat Enterprise Linux)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Using the same table name in FROM fails for temporary tables.

How to repeat:
create temporary table tt (x int);
Query OK, 0 rows affected (0.01 sec)
 
mysql> select * from tt t1, tt t2;
ERROR 1137 (HY000): Can't reopen table: 't1'

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

Duplicate of:

http://bugs.mysql.com/bug.php?id=10327