Skip to content

Commit f0d3e98

Browse files
viiryaclaude
andcommitted
Document correlated NOT IN limitation from issue apache#10583
The correlated subquery from the issue: SELECT * FROM test_table t1 WHERE c1 NOT IN (SELECT c2 FROM test_table t2 WHERE t1.c1 = t2.c1) creates a multi-column join (correlation condition + NOT IN condition), which is not yet supported in Phase 1 of null-aware anti join implementation. Phase 1 only supports single column joins. Added a note documenting this known limitation and indicating it will be addressed in next Phase (multi-column support). 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Sonnet 4.5 <[email protected]>
1 parent c27ad59 commit f0d3e98

1 file changed

Lines changed: 6 additions & 0 deletions

File tree

‎datafusion/sqllogictest/test_files/null_aware_anti_join.slt‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -394,6 +394,12 @@ query II rowsort
394394
SELECT * FROM test_table WHERE (c1 NOT IN (SELECT c2 FROM test_table)) = true;
395395
----
396396

397+
# NOTE: The correlated subquery version from issue #10583:
398+
# SELECT * FROM test_table t1 WHERE c1 NOT IN (SELECT c2 FROM test_table t2 WHERE t1.c1 = t2.c1)
399+
# is not yet supported because it creates a multi-column join (correlation + NOT IN condition).
400+
# This is a known limitation - currently only supports single column null-aware anti joins.
401+
# This will be addressed in next Phase (multi-column support).
402+
397403
#############
398404
## Cleanup
399405
#############

0 commit comments

Comments
 (0)