| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | <hackers(at)postgreSQL(dot)org> |
| Cc: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Postgres Hackers List <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Bug or feature? select, count(*), group by and empty tables |
| Date: | 1999-12-15 00:32:55 |
| Message-ID: | 3.0.1.32.19991214163255.010906b0@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 query
even 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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 1999-12-15 02:43:51 | RE: [HACKERS] Volunteer: Large Tuples / Tuple chaining |
| Previous Message | Don Baccus | 1999-12-15 00:11:39 | Bug or feature? select, count(*), group by and empty tables |