Re: Server crashed with dense_rank on partition table. - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Server crashed with dense_rank on partition table.
Date
Msg-id 20180613055534.GB26669@paquier.xyz
Whole thread Raw
In response to Server crashed with dense_rank on partition table.  (Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>)
Responses Re: Server crashed with dense_rank on partition table.
Re: Server crashed with dense_rank on partition table.
List pgsql-hackers
On Wed, Jun 13, 2018 at 11:08:38AM +0530, Rajkumar Raghuwanshi wrote:
> postgres=# SELECT dense_rank(b) WITHIN GROUP (ORDER BY a) FROM pagg_tab
> GROUP BY b ORDER BY 1;
> server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

Indeed, thanks for the test case.  This used to work in v10 but this is
failing with v11 so I am adding an open item.  The plans of the pre-10
query and the query on HEAD are rather similar, and the memory context
at execution time looks messed up.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Rajkumar Raghuwanshi
Date:
Subject: Server crashed with dense_rank on partition table.
Next
From: Masahiko Sawada
Date:
Subject: Re: Duplicate Item Pointers in Gin index