pgsql: Fix generate_union_paths for non-sortable types.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема pgsql: Fix generate_union_paths for non-sortable types.
Дата
Msg-id E1s9StW-001ES0-II@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Stamp 17beta1.
Следующее
От: noreply@postgresql.org
Дата:
Сообщение: pgsql: Tag refs/tags/REL_17_BETA1 was created