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

["Jungtaek Lim (JIRA)" <ji...@apache.org>]

Jungtaek Lim created CALCITE-1453:
-------------------------------------

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