Fix the issue that SJE mistakenly omits qual clauses

Title

Topic

Bug Fixes

Created

2023-12-28 11:30:27

Last modified

2024-01-09 11:00:59 (10 months, 3 weeks ago)

Latest email

2024-01-09 00:27:45 (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/4733
git checkout commitfest/cf/4733

Emails

BUG #18261: Inconsistent results of SELECT affected by joined subqueries: First at 2023-12-27 10:47:36 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2024-01-09 00:27:45 by Andrei Lepikhov <a.lepikhov at postgrespro.ru>
Latest attachment (tests_arrangement.diff) at 2024-01-05 03:32:26 from Andrei Lepikhov <a.lepikhov at postgrespro.ru>
    Attachment (tests_arrangement.diff) at 2024-01-05 03:32:26 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Fix-the-issue-that-SJE-mistakenly-omits-qual-clau-v2.patch) at 2024-01-02 08:02:11 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-the-issue-that-SJE-mistakenly-omits-qual-clauses.patch) at 2023-12-28 11:01:47 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2024-01-09 11:00:59	Richard Guo (richardguo)	Closed in commitfest 2024-01 with status: Committed
2024-01-09 11:00:59	Richard Guo (richardguo)	Changed committer to smagen
2023-12-28 11:30:46	Richard Guo (richardguo)	Changed authors to Richard Guo (richardguo)
2023-12-28 11:30:27	Richard Guo (richardguo)	Attached mail thread 18261-2a75d748c928609b@postgresql.org
2023-12-28 11:30:27	Richard Guo (richardguo)	Created patch record