[jira] Updated: (DERBY-1837) Select from a derived table does not return the aliased column names in some cases

["Daniel John Debrunner (JIRA)" <de...@db.apache.org>]

     [ 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