回复： BUG #18568: BUG: Result wrong when do group by on partition table!

I agree with advice of code style, and I have trim trailing whitespace in V6 patch.

About test case added in file partition_aggregate.sql, for we create case_insentitive collation based on ICU, which regress sql file we should write is better ?
If write into collate.icu.utf8.sql, it seems not suitable.

狂奔的蜗牛
1105066510(at)qq(dot)com

 

------------------ 原始邮件 ------------------
发件人: "Tender Wang" <tndrwang(at)gmail(dot)com&gt;;
发送时间:&nbsp;2024年8月8日(星期四) 下午4:20
收件人:&nbsp;"jian he"<jian(dot)universality(at)gmail(dot)com&gt;;
抄送:&nbsp;"狂奔的蜗牛"<1105066510(at)qq(dot)com&gt;;"pgsql-bugs"<pgsql-bugs(at)lists(dot)postgresql(dot)org&gt;;"aleksander"<aleksander(at)timescale(dot)com&gt;;
主题:&nbsp;Re: BUG #18568: BUG: Result wrong when do group by on partition table!

jian he <jian(dot)universality(at)gmail(dot)com&gt; 于2024年8月8日周四 15:51写道：

On Wed, Aug 7, 2024 at 11:04 PM jian he <jian(dot)universality(at)gmail(dot)com&gt; wrote:
&gt;
&gt; On Wed, Aug 7, 2024 at 9:08 PM 狂奔的蜗牛 <1105066510(at)qq(dot)com&gt; wrote:
&gt; &gt;
&gt; &gt; I readd RelabelType to branch in v5 patch, and add case to cover the code.
&gt; &gt;


I did some minor adjustments in group_by_has_partkey, also refactored
the comment.

The logic in patch I think no problem. But I don't like the code style.

if (IsA(groupexpr, RelabelType))
&nbsp; &nbsp; &nbsp;groupexpr = ((RelabelType *) groupexpr)-&gt;arg;

if (expr(groupexpr, partexr) &amp;&amp; partcoll == groupcoll)
{
...
}

This looks more compact.

By the way, I think we'd better to include test cases together in your patch, then others can continue
to work based on your patch not need to go back to add the test cases.

--
Tender Wang