Re: nested join bug

For the record, Toby sent me a personal email the next day with the
patch, which solved my problem when I got around to applying it a few
days later.

Thanks, Toby, for your continued excellent support of Mckoi.

--
Jim

On Wed, Nov 17, 2004 at 02:29:52PM -0800, Tobias Downer wrote:
> Date: Wed, 17 Nov 2004 14:29:52 -0800
> From: Tobias Downer <[email protected]>
> To: [email protected]
> Subject: Re: nested join bug
> 
> Jim,
> 
> I have a patch for this bug.  If you need it right away or would like to 
> test it, email me and I'll forward it to you.  I will be updating CVS soon.
> 
> Toby.
> 
> Jim McBeath wrote:
> >Using mckoi 1.0.3:
> >
> >1. The following statement works, returns 'b':
> >    select 'b'
> >
> >2. The following statement also works, returns 'c':
> >    select 'c' from (select 'd') left join (select 'e') on true
> >
> >3. The following statement fails, generating an MSQLException
> >   with the error string "-1":
> >    select 'a' from
> >    (select 'b')
> >    left join
> >    (select 'c' from (select 'd') left join (select 'e') on true)
> >    on true
> >
> >The form of the failed statement 3 is the same as the form of statement 2,
> >except that the right table of the join uses a nested join.
> >
> >--
> >Jim McBeath


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]