BUG #2017: column labels ignored on selects from views

The following bug has been logged online:

Bug reference:      2017
Logged by:          Jolly Chen
Email address:      jolly@gauntletsystems.com
PostgreSQL version: 8.1RC1
Operating system:   Mac OS X 10.4.3
Description:        column labels ignored on selects from views
Details:

Note how the column labels work for v2 but not for v1. This problem causes
columns to be mistakenly missing in JDBC ResultSets.


testdb=# create table foo (f1 integer);
CREATE TABLE
testdb=# insert into foo values (1);
INSERT 0 1
testdb=# insert into foo values (2);
INSERT 0 1
testdb=# create view v1 as select sum(f1) as sum from foo;
CREATE VIEW
testdb=# select * from v1;
 sum
-----
   3
(1 row)

testdb=# select sum as s from v1;
 sum
-----
   3
(1 row)

testdb=# create view v2 as select f1*10 as tenX from foo;
CREATE VIEW
testdb=# select * from v2;
 tenx
------
   10
   20
(2 rows)

testdb=# select tenX as t from v2;
 t
----
 10
 20
(2 rows)

testdb=# select version();
                                                                    version

----------------------------------------------------------------------------
-------------------------------------------------------------------
 PostgreSQL 8.1RC1 on powerpc-apple-darwin8.3.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc. build
5026)(1 row)

testdb=#