Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of rsjay1976@gmail.com
 designates 209.85.221.200 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=PHXF+gtg7i3ni+xW7Apz0vmGpMIHsIFYUUIcOLqHytAsr+ClisHoZvbkn8BGhHbgzm
         j9dipNlfvudeQFuVainQPG3Xo1ykJW+HKFYf8HWRKmlE7d8l+uo6ye5tP//DlX3xKk9S
         sKzIWVbzicTNZlrCMvlDfSGgvYA9yuuK7+kBs=
MIME-Version: 1.0
In-Reply-To: <4BD6741E.9080903@sun.com>
References: <4BC8A8AC.9060001@oracle.com>
	 <l2r59f746b91004180602y76527941w1135f2644881c240@mail.gmail.com>
	 <4BCB604C.6040003@sbcglobal.net>
	 <q2p59f746b91004210345j4f7cf58ra4d56e002b06b1a@mail.gmail.com>
	 <4BCEEB70.10902@sun.com>
	 <l2g30a84f761004210642nb3ae2c0fq592ad037f6ba4bb0@mail.gmail.com>
	 <4BCF1C53.8070003@oracle.com>
	 <j2g30a84f761004210919nd5c5e8eaz35fef54d0d683a4e@mail.gmail.com>
	 <g2w59f746b91004261939x1ee9638cu5c92e602262f9658@mail.gmail.com>
	 <4BD6741E.9080903@sun.com>
Date: Tue, 27 Apr 2010 08:14:40 -0400
Message-ID: <n2t59f746b91004270514v92add225i1c38cd4472cf6386@mail.gmail.com>
Subject: Re: gentle reminder: buddy testers needed
From: Jayaram Subramanian <rsjay1976@gmail.com>
To: derby-dev@db.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Thank Knut,

But i observed one more thing...  When i did
ResultSet rs=3Ds.executeQuery("select * from t1 join t2 using (a) join
t3 using (a)"); the query went through and was able to produce
results.

But when i did  s.executeQuery("select * from t1 join t2 using (a)
join t3 using (c)");  the query errored out


With Regards
Jayaram

On Tue, Apr 27, 2010 at 1:20 AM, Knut Anders Hatlen <Knut.Hatlen@sun.com> w=
rote:
> On 04/27/10 04:39, Jayaram Subramanian wrote:
>> Hi Knut,
>> I was continuing to buddy test the Derby 4370 (using clause) and when
>> trying to run the following hit the error attached... Dont know though
>> whether its a valid test or not
>>
>> s.execute("create table t1(a int, b int, c int)");
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 s.execute("create table t2(a int, b int, c i=
nt)");
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 s.execute("create table t3(a int, b varchar(=
5), c int)");
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 s.execute("insert into t1 values (1,2,3),(2,=
3,4),(4,4,4)");
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 s.execute("insert into t2 values (1,2,3),(2,=
3,4),(5,5,5)");
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 s.execute("insert into t3 values " +
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 "(2,'abc',8),(4,'def',10),(n=
ull,null,null)");
>>
>> ResultSet rs=3Ds.executeQuery("select * from t1 join t2 using (a) join
>> t3 using (c)");
>>
>>
>> Error encountered
>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>> java.sql.SQLSyntaxErrorException: Column name 'C' is in more than one
>> table in the FROM list.
>
> Hi Jayaram,
>
> I think this error is expected. Since both T1 and T2 contain a column
> named C, the second join operator doesn't know whether it should join on
> T1.C=3DT3.C or on T2.C=3DT3.C.
>
> Thanks,
>
> --
> Knut Anders
>