Don't constrain self join removal due to PHVs

Edit
ID 4668
Title Don't constrain self join removal due to PHVs
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2023-11-20 09:07:11
Last modified 2023-12-25 07:31:22 (1 year ago)
Latest email 2023-12-25 07:18:15 (1 year ago)
Status
2024-01 (2024-01-01 – 2024-01-31): 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