Fix improper qual pushdown after applying outer join identity 3

Title

Topic

Bug Fixes

Created

2023-02-28 19:14:20

Last modified

2023-05-17 17:55:48 (4 months, 2 weeks ago)

Latest email

2023-05-22 13:40:28 (4 months, 1 week ago)

Status

2023-07: Committed

2023-03: Moved to next CF

Target version

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