pgsql: For partitionwise join, match on partcollation, not parttypcoll.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: For partitionwise join, match on partcollation, not parttypcoll.
Date: 2018-02-28 17:22:11
Message-ID: E1er5Qh-000684-7Q@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

For partitionwise join, match on partcollation, not parttypcoll.

The previous code considered two tables to have the partition scheme
if the underlying columns had the same collation, but what we
actually need to compare is not the collations associated with the
column but the collation used for partitioning. Fix that.

Robert Haas and Amit Langote

Discussion: http://postgr.es/m/0f95f924-0efa-4cf5-eb5f-9a3d1bc3c33d@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2af28e603319224e87fd35ab62f36ef6de45eaac

Modified Files
--------------
src/backend/optimizer/util/plancat.c | 6 +++---
src/include/nodes/relation.h | 2 +-
2 files changed, 4 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Catalin Iacob 2018-02-28 17:43:09 Re: pgsql: Un-break parallel pg_upgrade.
Previous Message Robert Haas 2018-02-28 16:49:00 pgsql: Document LWTRANCHE_PARALLEL_HASH_JOIN.