Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...
Date
Msg-id 2151.1004472304@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Okay, I'm convinced: the problem is that the test for ungrouped vars
> used inside subselects is too simplistic.

Not only was that true, but the handling of GROUP BY expressions was
pretty grotty in general: they'd be re-evaluated at multiple levels of
the resulting plan tree.  Which is not too bad for "GROUP BY a+b",
but it's unpleasant when a complex subselect is involved.

I've committed fixes to CVS.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: timetz regression test is showing several DST-related failures
Next
From: Doug McNaught
Date:
Subject: Re: Performance problems???