Horton

Fix bogus logic for combining range-partitioned columns during pruning.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 51948c4e1fdef88ba9b953bd7b58d19a348732be
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2019-05-16T20:25:43Z
Releases: 11.4 
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

Files

PathChange+/−
src/backend/partitioning/partprune.c modified +9 −37
src/test/regress/expected/partition_prune.out modified +27 −0
src/test/regress/sql/partition_prune.sql modified +19 −0

Discussion