Fix improper qual pushdown after applying outer join identity 3

Edit
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, 2 months ago)
Latest email 2023-05-22 13:40:28 (1 year, 1 month 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
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