Accidental use of the PVC_RECURSE_WINDOWFUNCS flag? - Mailing list pgsql-hackers

From Antonin Houska
Subject Accidental use of the PVC_RECURSE_WINDOWFUNCS flag?
Date
Msg-id 31465.1588171520@antos
Whole thread Raw
Responses Re: Accidental use of the PVC_RECURSE_WINDOWFUNCS flag?  (Antonin Houska <ah@cybertec.at>)
List pgsql-hackers
I think that the PVC_RECURSE_WINDOWFUNCS flag shouldn't be used in
make_partial_grouping_target().

First, this function uses the grouping_target (see grouping_planner()) as the
input, and that should only contain the input expressions of window functions
as opposed to the window functions themselves. (make_window_input_target() is
responsible for pulling the input expressions from the window functions.)

Second, if a window function appeared in the result of
make_partial_grouping_target() for any reason, the Agg node would fail to
evaluate it. Am I wrong?

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com


Attachment

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Proposing WITH ITERATIVE
Next
From: Tomas Vondra
Date:
Subject: Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays