Postgres Pro
Downloads
Home   >   mailing lists

Re: array_agg(DISTINCT) caused a segmentation fault - Mailing list pgsql-bugs

From David Rowley
Subject Re: array_agg(DISTINCT) caused a segmentation fault
Date
Msg-id CAApHDvrp2xV0ekgTJM-dXWJaTUT71F-Zt5audrHF6=eH2b6vgg@mail.gmail.com
Whole thread Raw
In response to array_agg(DISTINCT) caused a segmentation fault  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-bugs
Tree view 
On Mon, 13 Feb 2023 at 18:29, Fujii Masao <masao.fujii@oss.nttdata.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17777: An assert failed in nodeWindowAgg.c
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.