Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func
Date
Msg-id 2063207.1704754792@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18277: Unexpected error: "WindowFunc not found in subplan target lists" triggered by JOIN and Window Func
Next
From: Nathan Bossart
Date:
Subject: Re: Wrong datatype in docs for wal_summary_keep_time