comphead commented on code in PR #17272:
URL: https://github.com/apache/datafusion/pull/17272#discussion_r2291643296
##########
datafusion/sqllogictest/test_files/array.slt:
##########
@@ -8072,6 +8072,18 @@ select [named_struct('a', 1, 'b', null)][-2];
----
NULL
+statement ok
+COPY (select [[true, false], [false, true]] a, [false, true] b union select
[[null, null]], null) to
'test_files/scratch/array/array_has/single_file.parquet' stored as parquet;
+
+statement ok
+CREATE EXTERNAL TABLE array_has STORED AS PARQUET location
'test_files/scratch/array/array_has/single_file.parquet';
+
+query B
+select array_contains(a, b) from array_has;
Review Comment:
Sorry @alamb I'm not sure I'm following, the reverse order would violate
`array_has` function signature.
```
Error during planning: Failed to coerce arguments to satisfy a call to
'array_has' function: coercion from [List(Field { name: "item", data_type:
Boolean, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }),
List(Field { name: "item", data_type: List(Field { name: "item", data_type:
Boolean, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }),
nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} })] to the
signature ArraySignature(Array { arguments: [Array, Element], array_coercion:
Some(FixedSizedListToList) }) failed No function matches the given name and
argument types 'array_has(List(Field { name: "item", data_type: Boolean,
nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }), List(Field
{ name: "item", data_type: List(Field { name: "item", data_type: Boolean,
nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }), nullable:
true, dict_id: 0, dict_is_ordered: false, metadata: {} }))'. You might need to
ad
d explicit type casts.
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
