Fix planner and rewriter to follow SQL semantics for tables that are

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 3eb1c8227751aecede58e742a13b07127a7e2652

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 1999-10-07T04:23:24Z

Fix planner and rewriter to follow SQL semantics for tables that are
mentioned in FROM but not elsewhere in the query: such tables should be
joined over anyway.  Aside from being more standards-compliant, this allows
removal of some very ugly hacks for COUNT(*) processing.  Also, allow
HAVING clause without aggregate functions, since SQL does.  Clean up
CREATE RULE statement-list syntax the same way Bruce just fixed the
main stmtmulti production.
CAUTION: addition of a field to RangeTblEntry nodes breaks stored rules;
you will have to initdb if you have any rules.

Files

Path	Change	+/−
src/backend/commands/view.c	modified	+3 −3
src/backend/executor/execMain.c	modified	+2 −3
src/backend/nodes/copyfuncs.c	modified	+2 −2
src/backend/nodes/equalfuncs.c	modified	+3 −1
src/backend/nodes/outfuncs.c	modified	+3 −2
src/backend/nodes/readfuncs.c	modified	+5 −1
src/backend/optimizer/plan/initsplan.c	modified	+26 −20
src/backend/optimizer/plan/planmain.c	modified	+73 −87
src/backend/optimizer/plan/planner.c	modified	+32 −21
src/backend/optimizer/util/clauses.c	modified	+26 −13
src/backend/parser/analyze.c	modified	+7 −25
src/backend/parser/gram.y	modified	+52 −50
src/backend/parser/parse_agg.c	modified	+24 −70
src/backend/parser/parse_clause.c	modified	+14 −3
src/backend/parser/parse_func.c	modified	+5 −3
src/backend/parser/parse_relation.c	modified	+23 −16
src/backend/rewrite/rewriteHandler.c	modified	+56 −35
src/include/nodes/parsenodes.h	modified	+34 −16
src/include/optimizer/planmain.h	modified	+3 −5
src/include/parser/parse_relation.h	modified	+3 −2
src/test/regress/expected/rules.out	modified	+2 −2