]> granicus.if.org Git - postgresql/commit
Fix bogus logic for combining range-partitioned columns during pruning.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 16 May 2019 20:25:43 +0000 (16:25 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 16 May 2019 20:25:43 +0000 (16:25 -0400)
commit3922f10646fc79264228ea3f6a7343cc3f8f528a
treeab8dc48bfe1aaf8437ecb025b18b64eef3bdd674
parent4b1fcb43d070ba8b34ea01d5a657630d76e4b33f
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
src/backend/partitioning/partprune.c
src/test/regress/expected/partition_prune.out
src/test/regress/sql/partition_prune.sql