Horton

Re: array_agg(DISTINCT) caused a segmentation fault

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-02-13T05:43:05Z
Lists: pgsql-bugs 
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

Commits

  1. Fix pfree issue in presorted DISTINCT aggregate code

  2. Fix incorrect presorted DISTINCT aggregate if condition