Re: BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN

Zu-Ming Jiang <zuming.jiang@inf.ethz.ch>

From: Zu-Ming Jiang <zuming.jiang@inf.ethz.ch>

To: Andrei Lepikhov <a.lepikhov@postgrespro.ru>, <pgsql-bugs@lists.postgresql.org>, PG Bug reporting form <noreply@postgresql.org>

Date: 2023-11-08T17:18:29Z

Lists: pgsql-bugs

> Great,
> I would like to have such fuzzer at the stage of development 😉 
Thanks for your appreciation!
I would like to open source the tool after my research paper on this 
tool get accepted.

Commits

Fix a comment for remove_self_joins_recurse()
- 0a93f803f45f 17.0 landed
Don't constrain self-join removal due to PHVs
- b5fb6736ed3b 17.0 landed
Handle PlaceHolderVar case in replace_varno_walker
- 8a8ed916f73f 17.0 landed
Fix how SJE checks against PHVs
- b7f315c9d7d8 17.0 landed
citext: Allow tests to pass in OpenSSL FIPS mode
- 3c551ebede46 17.0 cited