zhouqingqing / qpmodel
90%

DEFAULT BRANCH: master
Repo Added
Files 27
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

LAST BUILD ON BRANCH master
branch: master
CHANGE BRANCH
x

coverage: 89.935% (-0.03%) from 89.962%
24484307801

push

github

zhouqingqing 
Realize MarkJoin as HashJoin for IN/NOT IN subqueries (issue #272)

Replace nested-loop execution with hash-based execution for IN/NOT IN
derived MarkJoin. Hash on correlation (residual) keys, then evaluate
the marker predicate per-row for three-valued NULL logic. Falls back
to nested loop when no hashable residual keys exist. EXISTS/NOT EXISTS
MarkJoin continues to use nested loop.

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

4831 of 5711 branches covered (84.59%)

Branch coverage included in aggregate %.

158 of 166 new or added lines in 1 file covered. (95.18%)

1 existing line in 1 file now uncovered.

11512 of 12461 relevant lines covered (92.38%)

2866316.48 hits per line

Relevant lines Covered
12461 RELEVANT LINES 11512 COVERED LINES
2866316.48 HITS PER LINE
Source Files on master

Recent builds

Builds Branch Commit Type Ran Committer Via Coverage
24484307801 master Realize MarkJoin as HashJoin for IN/NOT IN subqueries (issue #272) Replace nested-loop execution with hash-based execution for IN/NOT IN derived MarkJoin. Hash on correlation (residual) keys, then evaluate the marker predicate per-row for three-v... push zhouqingqing github
89.94
24424533381 master Fix OR handling in inToMarkJoin and scalarToSingleJoin (issue #271) Previously only existsToMarkJoin handled OR expressions correctly. When a correlated IN subquery or scalar subquery appeared inside an OR expression (e.g., "a1 IN (select ...) OR... push zhouqingqing github
89.96
24360745217 master Fix CROSS JOIN crash and LEFT JOIN filter pushdown - Fix CROSS JOIN and NATURAL JOIN NullReferenceException when join has no ON clause (null constraint handling in parser and plan) - Fix LEFT JOIN filter pushdown: WHERE filters on the null-supp... push zhouqingqing github
89.96
24166647078 master Add IS/IS NOT to NOT relop push-in NOT (X IS NULL) now simplifies to X IS NOT NULL, and vice versa. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com> push zhouqingqing github
90.49
24143238858 master Fix grammar, spelling, and formatting in README.md - Capitalize proper nouns: C#, .NET Core, Python, Cascades, Visual Studio Code - Fix hyphenation: logic-centric, top-down/bottom-up, end-to-end, etc. - Fix subject-verb agreement and article usag... push zhouqingqing github
90.62
24142444290 master Address review: remove Semi break, fix test isolation, add regression tests - Remove early `break` in HashJoin Semi path (both codegen and non-codegen); rely solely on `matched_` flag to deduplicate, fixing correctness when multiple build row... push zhouqingqing github
90.62
24111817958 master Fix codegen left join matched_ marking and clarify AntiSemi comment - Fix codegen path missing v.matched_ = true for left join — non-codegen path marks matched build rows but codegen path did not, causing left join post-probe to incorrectly outpu... push zhouqingqing github
90.61
24111122770 master Fix OR-ed EXISTS decorrelation and restore sql06 test Neumann decorrelation now correctly detects subqueries inside OR expressions (e.g., EXISTS(A) OR EXISTS(B)) and falls back to the MarkJoin path, which preserves OR semantics through marker col... push zhouqingqing github
90.61
24107367784 master Merge: Neumann decorrelation improvements and test fixes - Fix HashJoin Semi dedup (skip already-matched build rows) - Exclude AntiSemi from HashJoin (stays on NLJ for NOT EXISTS) - Enable Neumann in TPCH benchmark tests, keep default off (sql06 ... push zhouqingqing github
90.64
24050362988 master Fix codegen left join matched_ marking and clarify AntiSemi comment - Fix codegen path missing v.matched_ = true for left join — non-codegen path marks matched build rows but codegen path did not, causing left join post-probe to incorrectly outpu... push zhouqingqing github
90.61
See All Builds (430)