[
https://issues.apache.org/jira/browse/CALCITE-7032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17959654#comment-17959654
]
xiong duan commented on CALCITE-7032:
-------------------------------------
Fixed in
[6ee860d|https://github.com/apache/calcite/commit/6ee860d4c95f025d1b34acad3564d3eee1833591].
Thanks for the review [~mbudiu] .
> Simplify 'NULL>ALL (ARRAY[1,2,NULL])' to 'NULL'
> -----------------------------------------------
>
> Key: CALCITE-7032
> URL: https://issues.apache.org/jira/browse/CALCITE-7032
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Assignee: xiong duan
> Priority: Major
> Labels: pull-request-available
>
> In SqlOperatorTest#testQuantifyCollectionOperators, Some unit test:
> {code:java}
> null = some (COLLECTION[1,2,3])
> null = some (COLLECTION[1,2,null])
> null = some (COLLECTION[null,null,null])
> COLLECTION can be ARRAY OR MULTISET.{code}
> Some invalid unit tests(should throw exception):
> {code:java}
> null = some (CAST ARRAY[10000,2,3] as tinyint ARRAY)
> null = some (CAST ARRAY[cast(10000 as tinyint array),2,3]){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
