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.
pgsql-hackers by date
|Next:||From: Brett McCormick||Date: 1998-01-27 08:44:50|
|Subject: weird query plans involving hash [join] & no indicies|
|Previous:||From: Goran Thyni||Date: 1998-01-27 08:39:42|
|Subject: Re: [HACKERS] postmaster crash and .s.pgsql file|