Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4BD9B29D.9090602@oracle.com>
Date: Thu, 29 Apr 2010 09:23:57 -0700
From: Rick Hillegas <rick.hillegas@oracle.com>
User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228)
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: Buddy Testing of Using Clause
References: <w2r59f746b91004281931uedce4e7clb02f89f1a33aa13c@mail.gmail.com>
 <z2p59f746b91004290833v3a8b3c7yc068d005194debc7@mail.gmail.com>
In-Reply-To: <z2p59f746b91004290833v3a8b3c7yc068d005194debc7@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Jayaram,

The Reference Guide documents a fair amount of complexity related to the 
USING clause:

1) In expanding * in the SELECT list, both when * occurs by itself and 
when it is qualified with a table name

2) In transforming the USING clause into an ON clause when the column 
names are unqualified for different kinds of joins

It would be great if you could verify these cases.

Thanks,
-Rick

Jayaram Subramanian wrote:
> Hi,
> Could  i have your thoughts and more ideas for testing the "using"
> functionality..
>
> With Regards
> Jayaram
>
> On Wed, Apr 28, 2010 at 10:31 PM, Jayaram Subramanian
> <rsjay1976@gmail.com> wrote:
>   
>> Hi,
>> I tried the following view based scenario of the using clause and
>> found the code flow through without issues
>> s.execute("create table t1(a int, b int, c int)");
>> s.execute("create table t2(a int, b int, c int)");
>> s.execute("create table t3(a int, b varchar(5), c int)");
>> s.execute("create view aview(a,b) as select a,t3.c from t1 join t3
>> using (c,a)");
>>                s.execute("insert into t1 values (1,2,3),(2,3,4),(4,4,4)");
>>                s.execute("insert into t2 values (1,2,3),(2,3,4),(5,5,5)");
>>                s.execute("insert into t3 values " +
>>                        "(2,'abc',8),(4,'def',10),(null,null,null)");
>> ResultSet rs=s.executeQuery("select * from aview join t1 using (b)");
>>
>> With Regards
>> Jayaram
>>
>>     
>
>