Fix improper qual pushdown after applying outer join identity 3

4222

Title

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, 5 months 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

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