Horton

Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: zuming.jiang@inf.ethz.ch, David Rowley <dgrowleyml@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2024-01-23T13:52:55Z
Lists: pgsql-bugs 
Richard Guo <guofenglinux@gmail.com> writes:
> Hmm, is there a way to detect in find_window_run_conditions() whether
> the WindowFunc's argument references a SubLink node of a subquery that
> hasn't been pulled up?

contain_subplans will recognize both SubLinks and SubPlans,
so there must be some other factor here.  (I didn't look yet.)

			regards, tom lane

Commits

  1. Fix query pullup issue with WindowClause runCondition

  2. Make documentation builds reproducible

  3. Teach planner about more monotonic window functions