Problem with multiple SUMs
| От | D'Arcy" "J.M." Cain |
|---|---|
| Тема | Problem with multiple SUMs |
| Дата | |
| Msg-id | m105URn-0000bnC@druid.net обсуждение |
| Ответы |
Re: [HACKERS] Problem with multiple SUMs
Re: [HACKERS] Problem with multiple SUMs |
| Список | 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@{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.
В списке pgsql-hackers по дате отправления: