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

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

From
tgl@postgresql.org (Tom Lane)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql
Changes by:    tgl@postgresql.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.