pgsql: Fix bogus logic for combining range-partitioned columns duringp

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix bogus logic for combining range-partitioned columns duringp
Дата
Msg-id E1hRMwq-0004g7-Dn@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix bogus logic for combining range-partitioned columns during pruning.

gen_prune_steps_from_opexps's notion of how to do this was overly
complicated and underly correct.

Per discussion of a report from Alan Jackson (though this fixes only one
aspect of that problem).  Back-patch to v11 where this code came in.

Amit Langote

Discussion: https://postgr.es/m/FAD28A83-AC73-489E-A058-2681FA31D648@tvsquared.com

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/51948c4e1fdef88ba9b953bd7b58d19a348732be

Modified Files
--------------
src/backend/partitioning/partprune.c          | 46 ++++++---------------------
src/test/regress/expected/partition_prune.out | 27 ++++++++++++++++
src/test/regress/sql/partition_prune.sql      | 19 +++++++++++
3 files changed, 55 insertions(+), 37 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix partition pruning to treat stable comparison operatorsprope
Следующее
От: Peter Geoghegan
Дата:
Сообщение: pgsql: Remove extra nbtree half-dead internal page check.