Re: PostgreSQL 10: Segmentation fault when using GROUPING SETS with all unsortable columns

From: Andres Freund <andres(at)anarazel(dot)de>
To: Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com>
Subject: Re: PostgreSQL 10: Segmentation fault when using GROUPING SETS with all unsortable columns
Date: 2018-03-19 22:22:09
Message-ID: 20180319222209.fbls5xuvcdesanqs@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2018-03-17 23:43:22 +0000, Huong Dangminh wrote:
> Hi,
>
> I have found a case which could get segmentation fault when using GROUPING SETS.
> It occurs when columns in GROUPING SETS are all unsortable but hashable.
>
> Attached grouping_sets_segv.zip include module to reproduce this problem.
>
> I think it made from below change.
>
> https://www.postgresql.org/docs/current/static/release-10.html#id-1.11.6.8.5.3.6
> ---
> Allow hashed aggregation to be used with grouping sets (Andrew Gierth)
> ---
> https://github.com/postgres/postgres/commit/b5635948ab165b6070e7d05d111f966e07570d81

Andrew, any comments?

Regards,

Andres

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-03-19 23:15:36 Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs
Previous Message Huong Dangminh 2018-03-19 22:15:36 RE: PostgreSQL 10: Segmentation fault when using GROUPING SETS with all unsortable columns