Re: array_agg(DISTINCT) caused a segmentation fault

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: array_agg(DISTINCT) caused a segmentation fault
Дата
Msg-id CAApHDvrdsHDDnFLZJ9hvaodyYkajdtaqub7Ss-Eq4sY4FYZW5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: array_agg(DISTINCT) caused a segmentation fault  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: array_agg(DISTINCT) caused a segmentation fault
Список pgsql-bugs
On Mon, 13 Feb 2023 at 23:00, Alexander Lakhin <exclusion@gmail.com> wrote:
> I've encountered an issue that could have the same title but it still reproduced after the fix.
> The following query:
> SELECT array_agg(DISTINCT a ORDER BY a DESC)
>           FROM (VALUES (1),(1.0),(NULL)) v(a);

Thanks for testing that.  I neglected to update the logic which pfrees
the old Datum, which (as of 7da51590e) may now be NULL.

I've just pushed a fix.

David



В списке pgsql-bugs по дате отправления:

Предыдущее
От: xianliang.ji@esgyn.cn
Дата:
Сообщение: Optimizer failed to generate plan
Следующее
От: David Rowley
Дата:
Сообщение: Re: Optimizer failed to generate plan