Re: array_agg(DISTINCT) caused a segmentation fault

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: array_agg(DISTINCT) caused a segmentation fault
Date: 2023-02-13 05:43:05
Message-ID: CAApHDvrp2xV0ekgTJM-dXWJaTUT71F-Zt5audrHF6=eH2b6vgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 13 Feb 2023 at 18:29, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> wrote:
> =# SELECT array_agg(distinct val) FROM (SELECT NULL AS val FROM generate_series(1, 2)) hoge;
>
> LOG: server process (PID 76507) was terminated by signal 11: Segmentation fault: 11

Thanks for the report. Looks like mine as there's no crash with: set
enable_presorted_aggregate=0;

David

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro Horiguchi 2023-02-13 06:45:49 Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Previous Message Tom Lane 2023-02-13 05:30:02 Re: BUG #17777: An assert failed in nodeWindowAgg.c