db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1837) Select from a derived table does not return the aliased column names in some cases
Date Sat, 09 Sep 2006 02:35:22 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1837?page=all ]

Daniel John Debrunner updated DERBY-1837:
-----------------------------------------

    Component/s: Tools
                     (was: SQL)

This, I think, is a feature of ij, not SQL. Ij is basing its column width on the display size
of the column, in the case one.
ij then tries to fit the column name into the display size of the column, again one, indicating
it is truncated with
an '&' symbol. So in this case, there is only space for '&'.

Maybe ij could have some minimum display size for a column, so that  at least some of the
column name was displayed.

> 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