You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/09/09 05:13:22 UTC
[jira] Commented: (DERBY-1837) Select from a derived table does not
return the aliased column names in some cases
[ http://issues.apache.org/jira/browse/DERBY-1837?page=comments#action_12433545 ]
Daniel John Debrunner commented on DERBY-1837:
----------------------------------------------
Very strange, the problem does only seem to be for derived tables:
ij> create table t (c char(1), c1 char(1), cxxxxxxxxxxxxxx char(1));
0 rows inserted/updated/deleted
ij> select * from t;
C |C1 |CXX&
--------------
0 rows selected
ij> select * from (values('a','a')) as 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