sorry for only half-using mysqlbug,
Martin
>Description:
When using more than one alias on a temporary table I get the error
message:
ERROR 1137: Can't reopen table: 'first_alias_name'
The only thing I found about this error is a fix in version 3.23.36
which seems to cope with the topic...
The same error seems to occur in older versions too... I verified it
with '4.0.3-beta'.
>How-To-Repeat:
CREATE TEMPORARY TABLE tmp (
id INT NOT NULL
);
SELECT T1.id FROM tmp T1, tmp T2;
-> ERROR 1137: Can't reopen table: 'T1'
>Fix:
???
>Submitter-Id:
>Originator: Martin Correll
>Organization:
>MySQL support: none
>Synopsis: Can't use more than one alias with temp-tables
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug or doc-bug
>Release: mysql-4.0.11-gamma-max (Official MySQL-max binary)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
debian linux
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
