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

Amit Langote <amitlangote09@gmail.com>

From: Amit Langote <amitlangote09@gmail.com>
To: jian he <jian.universality@gmail.com>
Cc: 狂奔的蜗牛 <1105066510@qq.com>, Tender Wang <tndrwang@gmail.com>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>, aleksander <aleksander@timescale.com>
Date: 2024-10-23T01:12:12Z
Lists: pgsql-bugs
On Tue, Oct 22, 2024 at 9:28 PM Amit Langote <amitlangote09@gmail.com> wrote:
> On Mon, Oct 21, 2024 at 5:10 PM jian he <jian.universality@gmail.com> wrote:
> >
> > On Thu, Aug 8, 2024 at 7:21 PM 狂奔的蜗牛 <1105066510@qq.com> wrote:
> > >
> > > Oh no!
> > > Sorry, I made a mistake on patch.
> > > v7 is new patch.
> >
> > regress tests will fail for build with.
> > -Dicu=disabled
> >
> > So I guess you have to put
> > src/test/regress/sql/partition_aggregate.sql related tests to
> > src/test/regress/sql/collate.icu.utf8.sql.
>
> Yes, I can see a regression diff such as this one when I push the
> patch to Cirrus CI:
>
> diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out
> /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out
> --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out
> 2024-10-22 07:42:10.098181779 +0000
> +++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out
> 2024-10-22 07:51:54.836528856 +0000
> @@ -1529,115 +1529,52 @@
>      locale = 'und-u-ks-level2',
>      deterministic = false
>  );
> +ERROR:  current database's encoding is not supported with this provider

My last 2 emails to 狂奔的蜗牛 (1105066510@qq.com) have been blocked.

-- 
Thanks, Amit Langote



Commits

  1. Disallow partitionwise grouping when collations don't match