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]