Re: BUG #17777: An assert failed in nodeWindowAgg.c

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, xinwen@stu.scu.edu.cn, pgsql-bugs@lists.postgresql.org
Date: 2023-02-13T19:45:17Z
Lists: pgsql-bugs
Hi,

On 2023-02-13 16:21:11 +1300, David Rowley wrote:
> On Mon, 13 Feb 2023 at 13:46, Andres Freund <andres@anarazel.de> wrote:
> > What about find_compatible_agg()? I don't think there's as severe
> > consequences, but it also doesn't seem right as-is.
> 
> This does not seem related to the issue being reported here. It seems
> to me this would only affect the aggregate deduplication logic and
> nothing else.

Fair enough.

I guess I was influenced by my thinking that we ought to combine more of the
relevant logic between "plain" aggregates and window functions.

Greetings,

Andres Freund



Commits

  1. Disable WindowAgg inverse transitions when subplans are present