I found this conversation when searching the archive for information about selfjoins on temporary tables.
I was primarily wondering what "in one of future releases" mean. What branch and what timeframe are we talking about? stable, beta, development? in a year, a month, or? regards, Gustav Munkby Sinisa Milivojevic writes: > Benjamin Stapley writes: > > > > I don't seem to be able to perform a self-join with a temporary > > table. > > Is the any good reason why this should not work? > > > > CREATE TEMPORARY table test TYPE=HEAP SELECT ..... FROM ..... > > WHERE ......; > > SELECT T.term , Q.term FROM test as T, test as Q WHERE .....; > > > > This generates the error message :- > > Can't reopen table: 'T' > > Many thanks > > > > Ben Stapley > > > Hi! > > This is a known issue. > > We shall try to fix it in one of future releases. > > Regards, > > Sinisa > -- NEU: WLAN-Router für 0,- EUR* - auch für DSL-Wechsler! GMX DSL = supergünstig & kabellos http://www.gmx.net/de/go/dsl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]