Re: [PORTS] Port Bug Report: Result not "GROUPED BY" from SQL: select im,bn,count(adr) FROM logtmp GROUP BY im,bn;

Поиск
Список
Период
Сортировка
От Vadim B. Mikheev
Тема Re: [PORTS] Port Bug Report: Result not "GROUPED BY" from SQL: select im,bn,count(adr) FROM logtmp GROUP BY im,bn;
Дата
Msg-id 34CD9D9A.9AB9E39A@sable.krasnoyarsk.su
обсуждение исходный текст
Список pgsql-hackers
Unprivileged user wrote:
>
> Category                : runtime: back-end: SQL
> Severity                : critical
>
> Summary: Result not "GROUPED BY" from SQL:
> select im,bn,count(adr) FROM logtmp GROUP BY im,bn;

I found from where it comes: nodeGroup.c' funcs assume that slots from
subplan (node Sort) have ttc_shouldFree = FALSE. This was right before
6.2 and is right for in-memory sorts, but wrong for disk ones.
Node Mergejoin uses some tricks to deal with this - #define MarkInnerTuple...
At the moment, I haven't time to fix this bug - will do this latter
if no one else.

Vadim

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

Предыдущее
От: Goran Thyni
Дата:
Сообщение: Re: [HACKERS] postmaster crash and .s.pgsql file
Следующее
От: Goran Thyni
Дата:
Сообщение: Re: [HACKERS] postmaster crash and .s.pgsql file