Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func

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

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

To: zuming.jiang@inf.ethz.ch

Cc: pgsql-bugs@lists.postgresql.org

Date: 2024-01-08T22:59:52Z

Lists: pgsql-bugs

PG Bug reporting form <noreply@postgresql.org> writes:
> My fuzzer finds a bug in Postgres 17devel, which triggers an unexpected
> error "ERROR: WindowFunc not found in subplan target lists".

Thanks for the report!  Bisecting says this broke at

2489d76c4906f4461a364ca8ad7e0751ead8aa0d is the first bad commit
commit 2489d76c4906f4461a364ca8ad7e0751ead8aa0d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Mon Jan 30 13:16:20 2023 -0500

    Make Vars be outer-join-aware.

so it's my fault and I'll take a closer look in a bit.

			regards, tom lane

Commits

Handle WindowClause.runCondition in tree walker/mutator functions.
- ee955321869e 16.2 landed
- c3f52fd5d716 15.6 landed
- d641b827af39 17.0 landed
Make dblink interruptible, via new libpqsrv APIs.
- d3c5f37dd543 17.0 cited
Make Vars be outer-join-aware.
- 2489d76c4906 16.0 cited