pgsql: Fix bogus logic for combining range-partitioned columns duringp
pgsql: Fix bogus logic for combining range-partitioned columns duringp
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/3922f10646fc79264228ea3f6a7343cc3f8f528a 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(-)