From: | "Jolly Chen" <jolly(at)gauntletsystems(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2017: column labels ignored on selects from views |
Date: | 2005-11-03 00:08:32 |
Message-ID: | 20051103000832.D7C76F117D@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2017
Logged by: Jolly Chen
Email address: jolly(at)gauntletsystems(dot)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=#
From | Date | Subject | |
---|---|---|---|
Next Message | Bernhard Weisshuhn | 2005-11-03 05:56:27 | BUG #2018: segfaults with some german errormessages |
Previous Message | Tom Lane | 2005-11-02 16:56:09 | Re: BUG #2014: createdb and other client binaries core dumps |