pgsql/src backend/nodes/copyfuncs.c backend/no ...

CVSROOT: /cvsroot
Module name: pgsql
Changes by: tgl(at)postgresql(dot)org 02/04/28 15:54:29

Modified files:
src/backend/nodes: copyfuncs.c equalfuncs.c outfuncs.c
readfuncs.c
src/backend/optimizer/plan: createplan.c initsplan.c planner.c
setrefs.c
src/backend/optimizer/util: clauses.c var.c
src/backend/parser: analyze.c parse_clause.c parse_relation.c
src/include/catalog: catversion.h
src/include/nodes: parsenodes.h plannodes.h
src/include/optimizer: planmain.h var.h
src/include/parser: parse_relation.h
src/test/regress/expected: join.out
src/test/regress/sql: join.sql

Log message:
Second try at fixing join alias variables. Instead of attaching miscellaneous
lists to join RTEs, attach a list of Vars and COALESCE expressions that will
replace the join's alias variables during planning. This simplifies
flatten_join_alias_vars while still making it easy to fix up varno references
when transforming the query tree. Add regression test cases for interactions
of subqueries with outer joins.