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: local policy)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; CHARSET=US-ASCII
Date: Wed, 28 Apr 2010 13:07:38 +0200
From: Knut Anders Hatlen <Knut.Hatlen@Sun.COM>
Subject: Re: gentle reminder: buddy testers needed
In-reply-to: <v2l59f746b91004280349w39013c3bq7fada66829d6f8c0@mail.gmail.com>
Sender: Knut.Hatlen@Sun.COM
To: derby-dev@db.apache.org
Message-id: <4BD816FA.90202@sun.com>
References: <4BC8A8AC.9060001@oracle.com>
 <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>
 <n2t59f746b91004270514v92add225i1c38cd4472cf6386@mail.gmail.com>
 <4BD6F657.9030808@sun.com>
 <v2l59f746b91004280349w39013c3bq7fada66829d6f8c0@mail.gmail.com>
User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US;
 rv:1.9.1.9) Gecko/20100318
 Thunderbird/3.0.4

On 04/28/10 12:49, Jayaram Subramanian wrote:
> Thanks for your comments Knut
> I verified that the error did go off when i tried something like this
> 
> ResultSet rs=s.executeQuery("select t3.c from t1 join t2 using (a,c)
> join t3 using (c)");
> 
> Also i was trying a subquery based scenario
> ResultSet rs=s.executeQuery("Select * from t1 where a in (select a
> from t2 join t1 using a)");
                  ^^^^^^^

Hi Jayaram,

There is a typo in that last query. It should say "using (a)" (note the
parentheses around the column name). With that change, I believe it
should work with an IN subquery too.

Thanks,
-- 
Knut Anders