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

5324

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2024-10-25 07:38:27

Last modified

2024-11-08 08:47:55 (4 months ago)

Latest email

2024-11-08 09:27:32 (4 months ago)

Status

2024-11: 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