[jira] [Commented] (CALCITE-1453) Support ANY type with binary compare / arithmetic operators

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15584182#comment-15584182 ] 

Julian Hyde commented on CALCITE-1453:
--------------------------------------

[~minjikim], [~jni], You've both done work on ANY. Any ideas?

> 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)