Don't constrain self join removal due to PHVs

Edit
Title Don't constrain self join removal due to PHVs
Topic Performance
Created 2023-11-20 09:07:11
Last modified 2023-12-25 07:31:22 (5 months ago)
Latest email 2023-12-25 07:18:15 (5 months ago)
Status
2024-01: Committed
Target version
Authors Richard Guo (richardguo)
Reviewers Become reviewer
Committer Alexander Korotkov (smagen)
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-12-25 07:18:15 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v4-0002-Don-t-constrain-self-join-removal-due-to-PHVs.patch) at 2023-12-05 02:35:03 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v4-0002-Don-t-constrain-self-join-removal-due-to-PHVs.patch) at 2023-12-05 02:35:03 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    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-12-25 07:31:22 Richard Guo (richardguo) Closed in commitfest 2024-01 with status: Committed
2023-12-25 07:31:22 Richard Guo (richardguo) Changed committer to smagen
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
Edit