HAVING clause and 6.3.2 release
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: hackers@postgreSQL.org (PostgreSQL-development)
Cc: ssimkovi@rainbow.studorg.tuwien.ac.at
Date: 1998-04-16T03:55:25Z
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? ---------------------------------------------------------------------------