Fix improper qual pushdown after applying outer join identity 3

Edit
ID 4222
Title Fix improper qual pushdown after applying outer join identity 3
Topic Bug Fixes
Created 2023-02-28 19:14:20
Last modified 2023-05-17 17:55:48 (1 year, 6 months ago)
Latest email 2023-05-22 13:40:28 (1 year, 6 months ago)
Status
2023-07: Committed
2023-03: Moved to next CF
Target version 16
Authors Tom Lane (tgl)
Reviewers Become reviewer
Committer Tom Lane (tgl)
Links CFbot results (CirrusCI) CFbot GitHub
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/4222
git checkout commitfest/cf/4222
Emails
Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware)
First at 2023-02-22 06:48:45 by Andrey Lepikhov <a.lepikhov at postgrespro.ru>
Latest at 2023-05-22 13:40:28 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v1-0001-Fix-thinko-in-outer-join-removal.patch) at 2023-05-18 08:58:21 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v1-0001-Fix-thinko-in-outer-join-removal.patch) at 2023-05-18 08:58:21 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v6-0006-Collect-pushed-down-outer-joins-in-add_outer_joins_to_relids.patch) at 2023-05-17 08:29:54 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Split-SpecialJoinInfo.commute_below-into-LHS-and-.patch) at 2023-05-17 03:10:45 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v5-0001-Split-SpecialJoinInfo.commute_below-into-LHS-and-.patch) at 2023-05-16 00:03:16 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v4-0001-Split-RestrictInfo.commute_below-into-LHS-and-RHS.patch) at 2023-05-12 17:25:10 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0003-Improve-add_outer_joins_to_relids.patch) at 2023-05-04 11:22:24 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Adjust-outer-join-s-target-list.patch) at 2023-04-21 09:34:18 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Adjust-outer-join-s-target-list.patch) at 2023-04-04 03:00:16 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Adjust-outer-join-s-target-list.patch) at 2023-04-01 02:15:54 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Draft-adjust-upper-quals.patch) at 2023-03-14 10:32:54 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (postpone-adding-pushed-down-ojrelid-to-relids.patch) at 2023-02-28 19:10:07 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
History
When Who What
2023-05-17 17:55:48 Tom Lane (tgl) Closed in commitfest 2023-07 with status: Committed
2023-05-17 17:55:48 Tom Lane (tgl) Changed committer to tgl
2023-04-21 09:50:07 Richard Guo (richardguo) New status: Needs review
2023-04-10 00:45:41 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-14 18:03:58 Tom Lane (tgl) New status: Waiting on Author
2023-02-28 19:14:46 Tom Lane (tgl) Changed authors to Tom Lane (tgl)
2023-02-28 19:14:46 Tom Lane (tgl) Changed targetversion to 16
2023-02-28 19:14:21 Tom Lane (tgl) Attached mail thread 0b819232-4b50-f245-1c7d-c8c61bf41827@postgrespro.ru
2023-02-28 19:14:20 Tom Lane (tgl) Created patch record
Edit