Re-allow planner to use Merge Append to efficiently implement UNION.
authorRobert Haas <rhaas@postgresql.org>
Tue, 21 May 2024 16:42:27 +0000 (12:42 -0400)
committerRobert Haas <rhaas@postgresql.org>
Tue, 21 May 2024 16:44:51 +0000 (12:44 -0400)
commit12933dc6048902ba891f9572cab96981f50ef669
tree3e14dabda4e36866611d8e2627b3925b011c00e3
parent3bd7b2f465deb48c0d37ed6a41bd864771f44390
Re-allow planner to use Merge Append to efficiently implement UNION.

This reverts commit 7204f35919b7e021e8d1bc9f2d76fd6bfcdd2070,
thus restoring 66c0185a3 (Allow planner to use Merge Append to
efficiently implement UNION) as well as the follow-on commits
d5d2205c83b1a7eb287487044d6.

Per further discussion on pgsql-release, we wish to ship beta1 with
this feature, and patch the bug that was found just before wrap,
rather than shipping beta1 with the feature reverted.
18 files changed:
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/sql/postgres_fdw.sql
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/path/equivclass.c
src/backend/optimizer/path/pathkeys.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/plan/subselect.c
src/backend/optimizer/prep/prepunion.c
src/backend/parser/analyze.c
src/include/nodes/pathnodes.h
src/include/optimizer/paths.h
src/include/optimizer/planner.h
src/include/optimizer/prep.h
src/test/regress/expected/collate.icu.utf8.out
src/test/regress/expected/incremental_sort.out
src/test/regress/expected/union.out
src/test/regress/sql/collate.icu.utf8.sql
src/test/regress/sql/union.sql