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 16:19:42 GMT
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 <rick.hillegas@oracle.com>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 <Knut.Hatlen@sun.com<mailto:
>> 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