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

Edit
ID 5324
Title Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.
Topic Bug Fixes
Created 2024-10-25 07:38:27
Last modified 2024-10-25 07:39:00 (1 week, 6 days ago)
Latest email 2024-11-06 03:19:45 (1 day, 6 hours ago)
Status
2024-11: Needs review
Target version
Authors Tender Wang (tndrwang)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5324
git checkout commitfest/cf/5324
Emails
Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.
First at 2024-10-23 13:48:11 by Tender Wang <tndrwang at gmail.com>
Latest at 2024-11-06 03:19:45 by jian he <jian.universality at gmail.com>
Latest attachment (v6-0002-Disallow-partitionwise-join-when-collation-doesn-.patch) at 2024-11-05 07:55:25 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v6-0002-Disallow-partitionwise-join-when-collation-doesn-.patch) at 2024-11-05 07:55:25 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-make-partition-wise-partitoin-aggreagte-relate.no-cfbot) at 2024-11-04 03:27:49 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Disallow-partitionwise-join-when-collation-doesn-.patch) at 2024-11-01 10:08:00 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Disallow-partitionwise-join-when-collation-doesn-.patch) at 2024-11-01 07:25:28 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Disallow-partitionwise-grouping-when-collation-do.patch) at 2024-10-31 13:08:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (partition_wise_join_collation.sql) at 2024-10-30 03:57:35 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (relnode.diff) at 2024-10-29 06:15:27 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-wrong-result-due-different-collation-between-col.patch) at 2024-10-23 13:48:11 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
History
When Who What
2024-10-25 07:39:00 Tender Wang (tndrwang) Changed authors to Tender Wang (tndrwang)
2024-10-25 07:38:27 Tender Wang (tndrwang) Attached mail thread CAHewXNno_HKiQ6PqyLYfuqDtwp7KKHZiH1J7Pqyz0nr+PS2Dwg@mail.gmail.com
2024-10-25 07:38:27 Tender Wang (tndrwang) Created patch record
Edit