HAVING clause and 6.3.2 release

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Cc: ssimkovi(at)rainbow(dot)studorg(dot)tuwien(dot)ac(dot)at
Subject: HAVING clause and 6.3.2 release
Date: 1998-04-16 03:55:25
Message-ID: 199804160355.XAA10940@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Attached is a list of bug reports for the HAVING clause.

My question is, "Do we disable the HAVING clause for 6.3.2?" The bugs
are serious and cause crashes.

I have looked at the issues, and the basic problems are that the
aggregate logic expects to be attached to an actual field in the target
list, and the HAVING clause does not properly handle non-aggregate
retrictions, nor does it prevent them. COUNT(*) uses the oid of the
first FROM table, so that is a problem too.

I have looked at the code, but don't have time to fix it before Friday,
and holding up the release for that would be silly. I don't think there
is one thing wrong, but several places that have to be change to get
this working solidly.

Do we disable it?

---------------------------------------------------------------------------

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message t-ishii 1998-04-16 04:20:19 Re: [PATCHES] ecpg patch
Previous Message Michael J Schout 1998-04-16 01:46:01 Patch for DBD-Pg-0.69..