Problem with multiple SUMs

From: "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net>
To: pgsql-hackers(at)PostgreSQL(dot)org
Subject: Problem with multiple SUMs
Date: 1999-01-27 12:51:55
Message-ID: m105URn-0000bnC@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

After recent changes I find an error with SUM when summing more than
one column. Here is the test sequence.

DROP TABLE x;
CREATE TABLE x (a int, b int);
INSERT INTO x VALUES (1, 5);
INSERT INTO x VALUES (2, 7);
SELECT * FROM x;
SELECT SUM(a) FROM x;
SELECT SUM(b) FROM x;
SELECT SUM(a), SUM(b) FROM x;

The last three statements give the following expected results when
run on a system compiled Jan 19.

darcy=> SELECT SUM(a) FROM x;
sum
---
3
(1 row)

darcy=> SELECT SUM(b) FROM x;
sum
---
12
(1 row)

darcy=> SELECT SUM(a), SUM(b) FROM x;
sum|sum
---+---
3| 12
(1 row)

On a system compiled Jan 27, I see the following.

darcy=> SELECT SUM(a) FROM x;
sum
---
3
(1 row)

darcy=> SELECT SUM(b) FROM x;
sum
---
12
(1 row)

darcy=> SELECT SUM(a), SUM(b) FROM x;
sum|sum
---+---
12| 12
(1 row)

See how the individual sums are correct but I can no longer get both
sums in one select.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-01-27 14:28:52 Re: Non-blocking queries in postgresql
Previous Message Michael Meskes 1999-01-27 11:50:35 Another small ecpg bug fixed