HAVING clause and 6.3.2 release - Mailing list pgsql-hackers

From Bruce Momjian
Subject HAVING clause and 6.3.2 release
Date
Msg-id 199804160355.XAA10940@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] HAVING clause and 6.3.2 release
Re: [HACKERS] HAVING clause and 6.3.2 release
List 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?

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


pgsql-hackers by date:

Previous
From: Michael J Schout
Date:
Subject: Patch for DBD-Pg-0.69..
Next
From: t-ishii@sra.co.jp
Date:
Subject: Re: [PATCHES] ecpg patch