Re: BUG #14344: string_agg(DISTINCT ..) crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14344: string_agg(DISTINCT ..) crash
Date
Msg-id 5760.1475155217@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #14344: string_agg(DISTINCT ..) crash  (Peter Geoghegan <pg@heroku.com>)
Responses Re: BUG #14344: string_agg(DISTINCT ..) crash
List pgsql-bugs
Peter Geoghegan <pg@heroku.com> writes:
> On Thu, Sep 29, 2016 at 5:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hm, works OK for me:
>>
>> regression=# SELECT string_agg(DISTINCT state, ',' ORDER BY state)
>> FROM string_agg_crash_test;
>> string_agg
>> -------------------
>> HI,IL,KS,MA,MA,NY
>> (1 row)

> Actually, it doesn't work for you, since "MA" appears twice. :-(

Hah ... it was too late at night for me to notice that ;-)

> A fix is in the works.

So you've identified the problem and the rest of us don't need to
chase it anymore?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: BUG #14344: string_agg(DISTINCT ..) crash
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #14344: string_agg(DISTINCT ..) crash