Re: Server crashed with dense_rank on partition table.

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Server crashed with dense_rank on partition table.
Дата
Msg-id 20180613055534.GB26669@paquier.xyz
обсуждение исходный текст
Ответ на Server crashed with dense_rank on partition table.  (Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>)
Ответы Re: Server crashed with dense_rank on partition table.  (David Rowley <david.rowley@2ndquadrant.com>)
Re: Server crashed with dense_rank on partition table.  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список 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

Вложения

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

Предыдущее
От: Rajkumar Raghuwanshi
Дата:
Сообщение: Server crashed with dense_rank on partition table.
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Duplicate Item Pointers in Gin index