db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: gentle reminder: buddy testers needed
Date Wed, 21 Apr 2010 12:11:28 GMT
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

View raw message