db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Kartha (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1837) Select from a derived table does not return the aliased column names in some cases
Date Sun, 10 Sep 2006 06:35:22 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1837?page=comments#action_12433673 ] 
            
Rajesh Kartha commented on DERBY-1837:
--------------------------------------

I am positive now this an ij issue, if I create a simple jdbc test I am able to get the correct
column names back.

                ResultSet rs=stmt.executeQuery("select * from (values('aaa','a')) as a(c1,c2)");
    		ResultSetMetaData rsmd=rs.getMetaData();
    		while(rs.next()){
    			System.out.println(rsmd.getColumnName(1)+"\t"+rsmd.getColumnName(2));
    			System.out.println(rs.getString(1)+"\t"+rs.getString(2));
    		}
    		System.out.println("====================================================");
    		rs=stmt.executeQuery("select * from (values('a','a')) as a(c1,c2)");
    		rsmd=rs.getMetaData();
    		while(rs.next()){
    			System.out.println(rsmd.getColumnName(1)+"\t"+rsmd.getColumnName(2));
    			System.out.println(rs.getString(1)+"\t"+rs.getString(2));
    		}

returns:

C1	C2
aaa	a
====================================================
C1	C2
a	a


> Select from a derived table does not return the aliased column names in some cases
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-1837
>                 URL: http://issues.apache.org/jira/browse/DERBY-1837
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.0, 10.1.3.1
>         Environment: Any
>            Reporter: Rajesh Kartha
>            Priority: Minor
>
> A select from a derived table does not return the aliased  column names correctly if
the selected column(s) are char(1). The column names
> show up as '&' in the following example:
> ij> select * from (values('a','a')) as a(c1,c2);
> &|&
> ---
> a|a
> 1 row selected
> ij> select * from (values('a','aa')) as a(c1,c2);
> &|C2
> ----
> a|aa
> 1 row selected
> ij> select * from (values('aaa','a')) as a(c1,c2);
> C1 |&
> -----
> aaa|a
> 1 row selected
> ij> select * from (values(1,'a')) as a(c1,c2);
> C1         |&
> -------------
> 1          |a
> 1 row selected

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message