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

2004-02-25 Thread John Heitmann
as foo, test as bar where foo.pk=bar.pk; Fix: Dropping the temporary from the above example fixes the problem, but is not a great solution. Submitter-Id: John Heitmann Originator: Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: Temp table can't be used

Re: Re: Erroneous results from a join after a delete

2002-01-31 Thread John Heitmann
On Thu, Jan 31, 2002 at 05:16:23PM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this