zhouqingqing / qpmodel / 24050087389

90%

push

github

Implement full Neumann decorrelation: D⋈ → regular Semi/AntiSemi join

- Push outer relation D down through subquery plan operators to leaf tables
- Convert dependent join to regular Semi/AntiSemi/Left joins with deparametrized predicates
- Semi joins use HashJoin; AntiSemi stays on NLJ (HashJoin anti-semi outputs unmatched probe rows, NOT EXISTS needs unmatched build rows)
- InSubqueryExpr falls back to existing inToMarkJoin path for NULL-aware semantics
- ScalarSubqueryExpr falls back to existing SingleJoin path
- replaceSubqueryInFilter targets original outer node D, not evolving result
- Add neumann regress test configuration (subqueryd_neumann.sql)

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

4484 of 5230 branches covered (85.74%)

Branch coverage included in aggregate %.

2 of 2 new or added lines in 1 file covered. (100.0%)

11144 of 12017 relevant lines covered (92.74%)

2799442.6 hits per line