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-22T12:28:40Z
Lists: pgsql-bugs
Hi,

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

--
Thanks, Amit Langote



Commits

  1. Disallow partitionwise grouping when collations don't match