Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] SELECT "bug"?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] SELECT "bug"?
Date: 2000-01-21 22:25:39
Message-ID: 9887.948493539@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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 SiffertDate: 2000-01-24 05:49:05
Subject: date('now') returns 12/31/99?
Previous:From: Tom LaneDate: 2000-01-21 22:16:36
Subject: Re: [BUGS] SELECT "bug"?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group