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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Curt Siffert 2000-01-24 05:49:05 date('now') returns 12/31/99?
Previous Message Tom Lane 2000-01-21 22:16:36 Re: [BUGS] SELECT "bug"?