[
https://issues.apache.org/jira/browse/CALCITE-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15606786#comment-15606786
]
Julian Hyde commented on CALCITE-1453:
--------------------------------------
Looks good. I will commit after the avatica-1.9.0 vote has passed.
> Support ANY type with binary compare / arithmetic operators
> -----------------------------------------------------------
>
> Key: CALCITE-1453
> URL: https://issues.apache.org/jira/browse/CALCITE-1453
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Jungtaek Lim
> Assignee: Jungtaek Lim
>
> Currently Calcite doesn't support applying binary compare / arithmetic
> operators with ANY type. One of example is
> CollectionTypeTest.testAccessNestedMapWithAnyTypeWithoutCast(). Without
> explicit casting, it can't find the matching backup method, and complaining
> there's no SqlFunctions.eq(Object, int).
> There seems to several ways to resolve this, but at least we don't want to
> make operator backup method for every combination of types. Needs to avoid
> this approach.
> When we're addressing this by having backup method, since we don't know the
> runtime type for ANY type, even if we succeed to call backup method with
> (Object, Object) parameters, two types can be different. This is OK for other
> types, but not Number types. This should be well cared, too.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)