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