Hi Rick, Thanks for choosing it for me. I'll start the testing on it. Thanks Eranda
On Wed, Apr 21, 2010 at 9:10 PM, Rick Hillegas <[email protected]>wrote: > Hi Eranda, > > How about DERBY-4550 (qualified identifiers in ij)? > > Thanks, > -Rick > > Eranda Sooriyabandara wrote: > >> 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 >> <[email protected]<mailto: >> [email protected]>> 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 >> >> >> >
