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 <vadim@sable.krasnoyarsk.su>
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Arkadiy Vavilin <ar@bizlink.ru>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-01-27T08:40:58Z
Lists: 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