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.
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2024-10-25 07:38:27
Last modified 2024-11-08 08:47:55 (11 months ago)
Latest email 2024-11-08 09:27:32 (11 months ago)
Status
2024-11 (2024-11-01 – 2024-11-30): Committed
Target version
Authors Tender Wang (tndrwang)
Reviewers Become reviewer
Committer Amit Langote (amitlan)
Links
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-08 09:27:32 by Amit Langote <amitlangote09 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-11-08 08:47:55 Tender Wang (tndrwang) Closed in commitfest 2024-11 with status: Committed
2024-11-08 08:47:55 Tender Wang (tndrwang) Changed committer to amitlan
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