You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit 04f3d7d
Browse filesBrowse the repository at this point in the historyBrowse files
test: cover mark-join plan shapes and NULL semantics for projected IN subqueries
Add plan guards for the two paths of a projected IN subquery: one null-aware
LeftMark join per subquery when the join filter is hashable only, and the
three-join materialization when a non-equality correlation stays as a residual
join filter. Add result tests for IN, NOT IN, EXISTS, an aggregate probe, a
CASE wrapper and a COALESCE wrapper over tables that hold NULL keys. The
expected values agree with DuckDB 1.5.2 and PostgreSQL 17.
Co-Authored-By: Claude Fable 5.1 <[email protected]>
# A non-equality correlation stays a residual join filter, so this query keeps
139
+
# the three-join materialization.
140
+
query TT
141
+
EXPLAIN SELECT id, id IN (SELECT n2.id FROM n2 WHERE n2.z < n1.z) AS m FROM n1;
142
+
----
143
+
logical_plan
144
+
01)Projection: n1.id, __correlated_sq_1.mark IS NOT DISTINCT FROM Boolean(true) OR (__correlated_sq_2.mark OR n1.id IS NULL AND __correlated_sq_3.mark) IS NOT DISTINCT FROM Boolean(true) AND __correlated_sq_1.mark IS DISTINCT FROM Boolean(true) AND Boolean(NULL) AS m
01)ProjectionExec: expr=[id@0 as id, mark@1 IS NOT DISTINCT FROM true OR (mark@2 OR id@0 IS NULL AND mark@3) IS NOT DISTINCT FROM true AND mark@1 IS DISTINCT FROM true AND NULL as m]
0 commit comments