Skip to content

Commit 9288448

Browse files
crm26claude
andcommitted
Update stale negative test in predicates.slt
The test at predicates.slt:845 asserted that `NULL IN (SELECT ...)` in a projection would fail with "Physical plan does not support logical expression InSubquery". With decorrelation of InSubquery in projections now supported, the query correctly returns (false, true) instead of erroring. Co-Authored-By: Claude Opus 4.6 (1M context) <[email protected]>
1 parent 12a12bc commit 9288448

1 file changed

Lines changed: 4 additions & 1 deletion

File tree

‎datafusion/sqllogictest/test_files/predicates.slt‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -843,12 +843,15 @@ explain select x from t where x NOT IN (1,2,3,4,5) AND x IN (1,2,3);
843843
logical_plan EmptyRelation: rows=0
844844
physical_plan EmptyExec
845845

846-
query error DataFusion error: This feature is not implemented: Physical plan does not support logical expression InSubquery\(InSubquery \{ expr: Literal\(Int64\(NULL\), None\), subquery: <subquery>, negated: false \}\)
846+
# IN and NOT IN against empty relation in a projection (decorrelated via DecorrelatePredicateSubquery)
847+
query BB
847848
WITH empty AS (SELECT 10 WHERE false)
848849
SELECT
849850
NULL IN (SELECT * FROM empty), -- should be false, as the right side is empty relation
850851
NULL NOT IN (SELECT * FROM empty) -- should be true, as the right side is empty relation
851852
FROM (SELECT 1) t;
853+
----
854+
false true
852855

853856
query I
854857
WITH empty AS (SELECT 10 WHERE false)

0 commit comments

Comments
 (0)