Log Message: ----------- Add support for doing FULL JOIN ON FALSE. While this is really a rather peculiar variant of UNION ALL, and so wouldn't likely get written directly as-is, it's possible for it to arise as a result of simplification of less-obviously-silly queries. In particular, now that we can do flattening of subqueries that have constant outputs and are underneath an outer join, it's possible for the case to result from simplification of queries of the type exhibited in bug #5263. Back-patch to 8.4 to avoid a functionality regression for this type of query. Tags: ---- REL8_4_STABLE Modified Files: -------------- pgsql/src/backend/executor: nodeMergejoin.c (r1.97 -> r1.97.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeMergejoin.c?r1=1.97&r2=1.97.2.1) pgsql/src/backend/optimizer/path: joinpath.c (r1.122 -> r1.122.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c?r1=1.122&r2=1.122.2.1) pgsql/src/include/nodes: execnodes.h (r1.205.2.1 -> r1.205.2.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h?r1=1.205.2.1&r2=1.205.2.2) pgsql/src/test/regress/expected: join.out (r1.36.2.2 -> r1.36.2.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out?r1=1.36.2.2&r2=1.36.2.3) pgsql/src/test/regress/sql: join.sql (r1.27.2.2 -> r1.27.2.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/join.sql?r1=1.27.2.2&r2=1.27.2.3)
pgsql-committers by date:
Соглашаюсь с условиями обработки персональных данных