[
https://issues.apache.org/jira/browse/CALCITE-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15603678#comment-15603678
]
Jungtaek Lim commented on CALCITE-1453:
---------------------------------------
Yes agreed. Let me add some tests on SqlFunctionsTest.
And I also think we can append postfix "Any" to backupMethod and call it as you
suggested. ANY type with not yet supported backupMethod will fail, but that
seems more clear on avoiding false-positive.
One thing to make it clear: Do we have any chance to receive Object type while
it's not rel type of ANY?
> 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)
