Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. - Mailing list pgsql-hackers

From Tender Wang
Subject Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.
Date
Msg-id CAHewXNk=FAwF5P1BX+3sEWH4vr_JLmXG-pJV8Q0n=ZXHaDtTAQ@mail.gmail.com
Whole thread Raw
In response to Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.  (Tender Wang <tndrwang@gmail.com>)
List pgsql-hackers
Tree view


Amit Langote <amitlangote09@gmail.com> 于2024年10月31日周四 21:09写道：

0001 is the patch for the partitionwise grouping issue (bug #18568).
I concluded that even partial aggregate should be disallowed when the
grouping collation doesn't match partitioning collation. The result
with partial partitionwise grouping is not the same as when
enable_partitionwise_aggregate is off.

LGTM 


--
Thanks,
Tender Wang

pgsql-hackers by date:

Previous
From: Tender Wang
Date:
Subject: Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.
Next
From: Peter Smith
Date:
Subject: Re: Pgoutput not capturing the generated columns