The Hermit Hacker <scrappy(at)hub(dot)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
In response to
pgsql-bugs by date
|Next:||From: Curt Siffert||Date: 2000-01-24 05:49:05|
|Subject: date('now') returns 12/31/99?|
|Previous:||From: Tom Lane||Date: 2000-01-21 22:16:36|
|Subject: Re: [BUGS] SELECT "bug"? |