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