Horton

For partitionwise join, match on partcollation, not parttypcoll.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 2af28e603319224e87fd35ab62f36ef6de45eaac
Author: Robert Haas <rhaas@postgresql.org>
Date: 2018-02-28T17:16:09Z
Releases: 11.0 
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

Files

PathChange+/−
src/backend/optimizer/util/plancat.c modified +3 −3
src/include/nodes/relation.h modified +1 −1

Discussion