nested join bug

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]