Re: [bug] Temp table cannot be used twice in a query

2004-02-26 Thread Victoria Reznichenko
John Heitmann [EMAIL PROTECTED] wrote: Description: When a temp table is included twice in a query mysql fails with the error: ERROR 1137 at line 9: Can't reopen table: 'foo' This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14. How-To-Repeat: create temporary

[bug] Temp table cannot be used twice in a query

2004-02-25 Thread John Heitmann
Description: When a temp table is included twice in a query mysql fails with the error: ERROR 1137 at line 9: Can't reopen table: 'foo' This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14. How-To-Repeat: create temporary table test (pk int primary key); select * from test as