Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Bug or feature? select, count(*), group by and empty tables - Mailing list pgsql-hackers

From Don Baccus
Subject Re: [HACKERS] Bug or feature? select, count(*), group by and empty tables
Date
Msg-id 3.0.1.32.19991214163255.010906b0@mail.pacifier.com
Whole thread Raw
In response to Bug or feature? select, count(*), group by and empty tables  (Don Baccus <dhogaza@pacifier.com>)
Responses Re: [HACKERS] Bug or feature? select, count(*), group by and empty tables
List pgsql-hackers
Tree view 
At 04:11 PM 12/14/99 -0800, Don Baccus wrote:
>Here's another anomaly I've run across in porting the Ars Digita
>Community System web development toolkit from Oracle to Postgres:

(always returning a row for a select count(*) ... group by queryeven if there aren't any groups)

OK, I've gotten the latest sources with the bright idea of digging
around, and in nodeAgg.c the routine ExecAgg.c has been somewhat
rewritten, with comments that make it clear that this bug's already
been fixed.

I should build myself a latest version so I can filter out non-problems
before reporting them, sorry...



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.

pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Bug or feature? select, count(*), group by and empty tables
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Volunteer: Large Tuples / Tuple chaining