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

5324

Title

Topic

Bug Fixes

Created

2024-10-25 07:38:27

Last modified

2024-11-08 08:47:55 (1 week, 5 days ago)

Latest email

2024-11-08 09:27:32 (1 week, 5 days ago)

Status

2024-11: Committed

Target version

Authors

Tender Wang (tndrwang)

Reviewers

Become reviewer

Committer

Amit Langote (amitlan)

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-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