Bug #15230 | can't use temporary table with union more then once | ||
---|---|---|---|
Submitted: | 24 Nov 2005 15:03 | Modified: | 24 Nov 2005 15:22 |
Reporter: | Nizamettin OZPOLAT | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.15 | OS: | Linux (SuSE Linux 9.0 (i586) - Kernel 2) |
Assigned to: | Bugs System | CPU Architecture: | Any |
[24 Nov 2005 15:03]
Nizamettin OZPOLAT
[24 Nov 2005 15:14]
Jorge del Conde
Hi! This is a documented fact: http://dev.mysql.com/doc/refman/5.0/en/temporary-table-problems.html "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'"
[24 Nov 2005 15:22]
Nizamettin OZPOLAT
It is also said with the version 4.0.* and 4.1.* but it used to work. What has changed?
[25 Nov 2005 9:08]
Sergei Golubchik
SELECT as in the Jorge's example never worked. UNION as in yours did work, because of the bug in the UNION - it did not lock tables correctly, making deadlocks possible. That bug was fixed since then.