Don't constrain self join removal due to PHVs

Title

Topic

Performance

Created

2023-11-20 09:07:11

Last modified

2023-11-20 09:07:23 (1 week, 6 days ago)

Latest email

2023-11-30 07:21:50 (3 days, 20 hours ago)

Status

2024-01: Needs review

Target version

Authors

Richard Guo (richardguo)

Reviewers

Committer

Links

Emails

BUG #18187: Unexpected error: "variable not found in subplan target lists" triggered by JOIN: First at 2023-11-07 17:04:23 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2023-11-30 07:21:50 by Andrei Lepikhov <a.lepikhov at postgrespro.ru>
Latest attachment (v3-0001-Don-t-constrain-self-join-removal-due-to-PHVs.patch) at 2023-11-28 07:03:49 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v3-0001-Don-t-constrain-self-join-removal-due-to-PHVs.patch) at 2023-11-28 07:03:49 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Don-t-constrain-self-join-removal-due-to-PHVs.patch) at 2023-11-20 08:49:13 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-how-SJE-checks-against-PHVs.patch) at 2023-11-10 08:20:52 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-how-SJE-removes-references-from-PHVs.patch) at 2023-11-09 03:54:08 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2023-11-20 09:07:23	Richard Guo (richardguo)	Changed authors to Richard Guo (richardguo)
2023-11-20 09:07:12	Richard Guo (richardguo)	Attached mail thread 18187-831da249cbd2ff8e@postgresql.org
2023-11-20 09:07:12	Richard Guo (richardguo)	Created patch record