Re: BUG #18568: BUG: Result wrong when do group by on partition table!

Tender Wang <tndrwang@gmail.com>

From: Tender Wang <tndrwang@gmail.com>

To: Amit Langote <amitlangote09@gmail.com>

Cc: jian he <jian.universality@gmail.com>, 1105066510@qq.com, pgsql-bugs@lists.postgresql.org

Date: 2024-11-08T09:36:49Z

Lists: pgsql-bugs

Amit Langote <amitlangote09@gmail.com> 于2024年11月8日周五 17:28写道：

> I've pushed the fix for this issue to all the branches down to 12.
>
> Thanks for the report and the analyses.
>

Thanks for pushing these collation-related fixed patches.

-- 
Thanks,
Tender Wang

Commits

Disallow partitionwise grouping when collations don't match
- 90fe6251c816 18.0 landed
- b6484ca9535e 17.1 landed
- dd2f8ebee221 16.5 landed
- 0a620659c549 15.9 landed
- 96f9b29a3e1e 14.14 landed
- ff65f695c0d3 13.17 landed
- 46d9be5efb1a 12.21 landed
For partitionwise join, match on partcollation, not parttypcoll.
- 2af28e603319 11.0 cited