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

Edit
ID 7080
Title Wrong results: NOT IN to anti-join with an upper-level Var in the sub-select's output
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-07-31 06:04:06
Last modified 2026-07-31 06:04:06 (2 hours ago)
Latest email 2026-07-31 07:21:16 (1 hour ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
Target version 19
Authors Rui Zhao (zhaorui)
Reviewers Become reviewer
Committer
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-07-31 07:21:16 by Tender Wang <tndrwang at gmail.com>
Latest 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>
    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-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
Edit