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

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: 狂奔的蜗牛 <1105066510(at)qq(dot)com>, Tender Wang <tndrwang(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>, aleksander <aleksander(at)timescale(dot)com>
Subject: Re: BUG #18568: BUG: Result wrong when do group by on partition table!
Date: 2024-10-22 12:28:40
Message-ID: CA+HiwqGLvxCjbEMzCRy221V88nmVPvWVp+kZbH5PLrsH1nPTFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Mon, Oct 21, 2024 at 5:10 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> On Thu, Aug 8, 2024 at 7:21 PM 狂奔的蜗牛 <1105066510(at)qq(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tender Wang 2024-10-22 14:29:10 Re: BUG #18568: BUG: Result wrong when do group by on partition table!
Previous Message Amit Langote 2024-10-22 12:11:23 Re: BUG #18568: BUG: Result wrong when do group by on partition table!