Hi,
On 2023-02-13 13:31:54 +1300, David Rowley wrote:
> On Mon, 13 Feb 2023 at 05:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Why is it okay to check only the filter, and not the rest of the
> > WindowFunc's subexpressions? The arguments we've just run through
> > seem to apply to a subplan in the direct or aggregated arguments
> > as well.
>
> Good point. I had just been thinking in terms of the reported bug to
> make sure we inverse transition the same rows we transition. We also
> need to make sure the transition value matches in both transition
> directions.
What about find_compatible_agg()? I don't think there's as severe
consequences, but it also doesn't seem right as-is.
Greetings,
Andres Freund