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: SQL
Affects Versions: 10.1.3.1, 10.1.3.0, 10.1.2.1, 10.1.1.0, 10.0.2.1, 10.0.2.0
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
