On Wednesday 05 March 2003 16:08, correll at gmx dot de wrote:
> >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'
>
It's not a bug. You can't use temporary table twice in the same query and it's
described in the manual at:
http://www.mysql.com/doc/en/Temporary_table_problems.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
