Accidental use of the PVC_RECURSE_WINDOWFUNCS flag?

From: Antonin Houska <ah(at)cybertec(dot)at>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Accidental use of the PVC_RECURSE_WINDOWFUNCS flag?
Date: 2020-04-29 14:45:20
Message-ID: 31465.1588171520@antos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
remove_PVC_RECURSE_WINDOWFUNCS.diff text/x-diff 530 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-04-29 15:17:35 Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays
Previous Message Jonah H. Harris 2020-04-29 14:33:46 Re: Proposing WITH ITERATIVE