pgsql: Fix generate_union_paths for non-sortable types.

2024-05-21 Thread Robert Haas
Fix generate_union_paths for non-sortable types. The previous logic would fail to set groupList when grouping_is_sortable() returned false, which could cause queries to return wrong answers when some columns were not sortable. David Rowley, reviewed by Heikki Linnakangas and Álvaro Herrera.

pgsql: Re-allow planner to use Merge Append to efficiently implement UN

2024-05-21 Thread Robert Haas
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 d5d2205c8, 3b1a7eb28, 7487044d6. Per

pgsql: Doc: return 66c0185a3 to the release notes.

2024-05-21 Thread Robert Haas
Doc: return 66c0185a3 to the release notes. This reverts commit e1e83a71715f1c2f0717bb66e630ca3bda79b9c1. Per further discussion on pgsql-release, we wish to ship beta1 with that feature, and patch the bug, rather than shipping beta1 with that feature reverted. Branch -- master Details