pgsql: Fix generate_union_paths for non-sortable types. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Fix generate_union_paths for non-sortable types.
Date
Msg-id E1s9StW-001ES0-II@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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.
Reported by Hubert "depesz" Lubaczewski.

Discussion: http://postgr.es/m/Zktzf926vslR35Fv@depesz.com
Discussion: http://postgr.es/m/CAApHDvra=c8_zZT0J-TftByWN2Y+OJfnjNJFg4Dfdi2s+QzmqA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c37267162e889fe783786b9e28d1b65b82365a00

Modified Files
--------------
src/backend/optimizer/prep/prepunion.c | 21 ++++++++++++---------
src/test/regress/expected/union.out    | 13 +++++++++++++
src/test/regress/sql/union.sql         |  6 ++++++
3 files changed, 31 insertions(+), 9 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Stamp 17beta1.
Next
From: noreply@postgresql.org
Date:
Subject: pgsql: Tag refs/tags/REL_17_BETA1 was created