Thread: Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.

Hi all,

I think the root cause of this thread and [1] are same.  We don't use the Partition Key collation but column's

collation to fill the RelOptInfo partexprs field in set_baserel_partition_key_exprs(). 

If the Partition Key definition is same as column definition,  which most times is, 

that will be ok. But if it's not, this thread issue will arise. 

As far as I know, only partition pruning logic considers not only call equal(), but also check collation match.

Other codes only call equal() to check if the exprs match the partition key.

For example, in this thread case, match_expr_to_partition_keys() think the expr match the partition key:

if (equal(lfirst(lc), expr))
    return cnt;

Although We can fix this issue like [1], I think why not directly use the partkey->partcollation[cnt], which its value is

same with pg_partitioned_table's partcollation. I tried this to fix [1], but at that time, I was unsure if it was the correct fix.

Until I find this thread issue, I think we should do it this way.

In the attached patch, I include this thread test and [1] test case.