Don't constrain self join removal due to PHVs

Title

Topic

Performance

Created

2023-11-20 09:07:11

Last modified

2023-12-25 07:31:22 (10 months, 3 weeks ago)

Latest email

2023-12-25 07:18:15 (10 months, 3 weeks ago)

Status

2024-01: Committed

Target version

Authors

Richard Guo (richardguo)

Reviewers

Committer

Alexander Korotkov (smagen)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4668
git checkout commitfest/cf/4668

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