db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eranda Sooriyabandara <erandaj...@gmail.com>
Subject Re: gentle reminder: buddy testers needed
Date Wed, 21 Apr 2010 13:42:58 GMT
Hi,
I think I can earn some time for look at one or may more. So if anyone can
choose one for me would be the best thing I think.
Thanks
Eranda

On Wed, Apr 21, 2010 at 5:41 PM, Knut Anders Hatlen <Knut.Hatlen@sun.com>wrote:

> On 04/21/10 12:45 PM, Jayaram Subramanian wrote:
> > Hi Knut,
> > For buddy testing of  Derby 4370 (using clause), I was going through
> > the jointest junit file to find the validation test cases and was just
> > wondering whether using both on and using in a singled sql statement
> > is allowed
> >
> > For example
> > JDBC.assertUnorderedResultSet(
> >                 s.executeQuery("select * from t1 left join t2 " +
> >                                "right join t3 on (d) using (b)"),
> >
>
> Hi Jayaram,
>
> It should be fine to mix ON and USING withing a single statement. The
> above statement should fail, though, because the ON clause ("on (d)") is
> invalid. The ON clause needs a boolean expression, like T2.A = T3.B.
>
> --
> Knut Anders
>
>

Mime
View raw message