(datafusion) 01/01: test: cover ArrayStaticFilter and dictionary flattening IN list (#25001)

[gi...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

github-merge-queue[bot] pushed a commit to branch gh-readonly-queue/main/pr-25001-57740cae88a2cd468900e9b89116b31887a90cbf
in repository https://gitbox.apache.org/repos/asf/datafusion.git

commit 38de90347e4a4475e4bd031d19c6e118734e97b2
Author: Peter Lee <pe...@gmail.com>
AuthorDate: Mon Sep 7 12:59:09 2026 +0000

    test: cover ArrayStaticFilter and dictionary flattening IN list (#25001)
    
    ## Which issue does this PR close?
    
    - Closes #23307.
    
    ## Rationale for this change
    
    The remaining specialized IN-list paths need SQL-level coverage to
    verify dispatch and end-to-end behavior.
    
    ## What changes are included in this PR?
    
    Adds SQL logic tests for:
    
    - generic `ArrayStaticFilter` values using lists
    - dictionary literal flattening
    
    The cases cover matches, non-matches, nulls, and `NOT IN` behavior where
    applicable.
    
    ## What is the testing strategy for this PR?
    
    slt
    
    ## Are there any user-facing changes?
    
    No.
---
 datafusion/sqllogictest/test_files/in_list.slt | 60 ++++++++++++++++++++++++++
 1 file changed, 60 insertions(+)

diff --git a/datafusion/sqllogictest/test_files/in_list.slt b/datafusion/sqllogictest/test_files/in_list.slt
index bc7adf76ea..3ff47afb64 100644
--- a/datafusion/sqllogictest/test_files/in_list.slt
+++ b/datafusion/sqllogictest/test_files/in_list.slt
@@ -767,3 +767,63 @@ nulls NULL NULL
 # Cleanup
 statement ok
 DROP TABLE in_list_fsb
+
+####
+## Generic ArrayStaticFilter
+####
+
+statement ok
+CREATE TABLE in_list_lists(label VARCHAR, value BIGINT[]) AS VALUES
+  ('match', [1, 2]),
+  ('no_match', [7, 8]),
+  ('nulls', NULL);
+
+# Five element IN lists bypass the short-list rewrite and use ArrayStaticFilter.
+query TBB
+SELECT
+  label,
+  value IN ([1, 2], [3, 4], [5, 6], [9, 10], [11, 12]),
+  value IN (NULL, [1, 2], [3, 4], [5, 6], [9, 10])
+FROM in_list_lists
+ORDER BY label
+----
+match true true
+no_match false NULL
+nulls NULL NULL
+
+statement ok
+DROP TABLE in_list_lists
+
+####
+## Dictionary Flattening
+####
+
+# Five dictionary literals exercise evaluate_list's dictionary flattening path.
+query TBB
+SELECT
+  label,
+  value IN (
+    arrow_cast('a', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('b', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('c', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('d', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('match', 'Dictionary(Int8, Utf8)')
+  ),
+  value NOT IN (
+    arrow_cast('a', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('b', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('c', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('d', 'Dictionary(Int8, Utf8)'),
+    arrow_cast('match', 'Dictionary(Int8, Utf8)')
+  )
+FROM (
+  VALUES
+    ('match', arrow_cast('match', 'Dictionary(Int8, Utf8)')),
+    ('no_match', arrow_cast('no_match', 'Dictionary(Int8, Utf8)')),
+    ('nulls', arrow_cast(NULL, 'Dictionary(Int8, Utf8)'))
+) AS t(label, value)
+ORDER BY label
+----
+match true false
+no_match false true
+nulls NULL NULL


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org