| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix bogus logic for combining range-partitioned columns during p |
| Date: | 2019-05-16 20:25:52 |
| Message-ID: | E1hRMwq-0004g7-Dn@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2019-05-16 22:14:13 | pgsql: Remove extra nbtree half-dead internal page check. |
| Previous Message | Tom Lane | 2019-05-16 15:58:32 | pgsql: Fix partition pruning to treat stable comparison operators prope |