Re: [BUGS] SELECT "bug"? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] SELECT "bug"?
Date
Msg-id 9887.948493539@sss.pgh.pa.us
Whole thread Raw
In response to SELECT "bug"?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-bugs
The Hermit Hacker <scrappy@hub.org> writes:
> webcounter=> select count(1) from webhit_details_formatted where counter_id = 1;
> [ crash ]

OK, this is a boundary condition that I fixed awhile ago: nodeAgg.c
coredumped if no tuples are selected *and* no attributes are mentioned
in the targetlist.  You can work around it in 6.5.* by writing
count(*) instead of count(1).

We could backpatch this, but I'm not sure it's worth the trouble,
considering the lack of complaints and the simplicity of the workaround.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] SELECT "bug"?
Next
From: "Curt Siffert"
Date:
Subject: date('now') returns 12/31/99?