Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1
-
None
-
Any
-
Normal
-
Repro attached
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