Repository navigation
Commit c27ad59
Add test case from GitHub issue apache#10583 for null-aware anti join
This test verifies that NOT IN with NULL in the subquery result correctly
returns an empty result set. The query tests the three-valued logic semantics:
Query: SELECT * FROM test_table WHERE (c1 NOT IN (SELECT c2 FROM test_table)) = true
Since the subquery result contains NULL, the NOT IN predicate evaluates to
UNKNOWN (not TRUE) for all rows, resulting in an empty output.
Test data:
- test_table: (1,1), (2,2), (3,3), (4,NULL), (NULL,0)
- Subquery returns: 1, 2, 3, NULL, 0
- Expected result: empty (because NULL in subquery makes all comparisons UNKNOWN)
Fixes apache#10583
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Sonnet 4.5 <[email protected]>1 parent ac06033 commit c27ad59
1 file changed
Lines changed: 22 additions & 0 deletions
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
375 | 375 | | |
376 | 376 | | |
377 | 377 | | |
| 378 | + | |
| 379 | + | |
| 380 | + | |
| 381 | + | |
| 382 | + | |
| 383 | + | |
| 384 | + | |
| 385 | + | |
| 386 | + | |
| 387 | + | |
| 388 | + | |
| 389 | + | |
| 390 | + | |
| 391 | + | |
| 392 | + | |
| 393 | + | |
| 394 | + | |
| 395 | + | |
| 396 | + | |
378 | 397 | | |
379 | 398 | | |
380 | 399 | | |
381 | 400 | | |
| 401 | + | |
| 402 | + | |
| 403 | + | |
382 | 404 | | |
383 | 405 | | |
384 | 406 | | |
| |||
0 commit comments