Wrong results: NOT IN to anti-join with an upper-level Var in the sub-select's output

Title

CI (CFBot)

Needs rebase! Needs rebase since 2 weeks. Failing since 2 weeks.
Additional links previous successfully applied patch (outdated):

Stats (from CFBot)

Unknown

Tags

Bugfix

Created

2026-07-31 06:04:06

Last modified

2026-08-03 19:33:28 (1 week ago)

Latest email

2026-08-03 07:07:15 (2 weeks ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Committed

Target version

Authors

Rui Zhao (zhaorui)

Reviewers

Become reviewer

Committer

Richard Guo (richardguo)

Links

Emails

Wrong results: NOT IN to anti-join with an upper-level Var in the sub-select's output: First at 2026-07-31 06:02:06 by Rui Zhao <zhaorui126 at gmail.com>
Latest at 2026-08-03 07:07:15 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v2-0001-Don-t-prove-a-sub-select-s-upper-level-output-Var.patch) at 2026-07-31 15:26:24 from Rui Zhao <zhaorui126 at gmail.com>
Attachment (v2-0001-Don-t-prove-a-sub-select-s-upper-level-output-Var.patch) at 2026-07-31 15:26:24 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
Attachment (v1-0001-notin-subselect-upper-level-output-var.patch.txt) at 2026-07-31 06:02:06 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)

History

When	Who	What
2026-08-03 19:33:28	Ayush Tiwari (aytiwari)	Closed in commitfest PG20-2 with status: Committed
2026-08-03 19:33:28	Ayush Tiwari (aytiwari)	Changed committer to richardguo
2026-08-03 09:38:38	CFbot	Patch needs rebase
2026-07-31 06:04:06	Rui Zhao (zhaorui)	Attached mail thread CAHWVJhGuaFFRpmq4j+mcMcm_HC5QOT7LZsC9bf9b7BCBmvbfMA@mail.gmail.com
2026-07-31 06:04:06	Rui Zhao (zhaorui)	Created patch record