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

2004-02-25 Thread John Heitmann
); select * from test 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: >MySQL support: none >Synopsis:

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 t

Erroneous results from a join after a delete

2002-01-31 Thread John Heitmann
go away. Thanks for looking at this, and thanks for a cool product, John Heitmann CombineNet # MySQL dump 8.16 # # Host: localhostDatabase: bug # # Server version3.23.47 # # Table structure for table 't1' # CREATE TABLE t1