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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1
• Component/s: Tools
• Labels: derby_triage10_5_2
• Environment: Any
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Rajesh Kartha
• Created: 09/Sep/06 01:09
• Updated: 15/Feb/11 21:08

Description

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