[jira] [Created] (CALCITE-3477) Geofunction do not support int type as input

["Kirils Mensikovs (Jira)" <ji...@apache.org>]

Kirils Mensikovs created CALCITE-3477:
-----------------------------------------

             Summary: Geofunction do not support int type as input
                 Key: CALCITE-3477
                 URL: https://issues.apache.org/jira/browse/CALCITE-3477
             Project: Calcite
          Issue Type: Bug
          Components: spatial
            Reporter: Kirils Mensikovs


Geospatial function with integer parameter fails. The expected behavior is to cast automatically all number values to BigDecimal.

{{Example: select  ST_MAKEPOINT(1.0, 1)}}

Return:
{{ Error: Error while executing SQL "select  ST_MAKEPOINT(1.0, 1)": Error while compiling generated Java code:}}{{public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) {}}{{  final org.apache.calcite.linq4j.Enumerable _inputEnumerable = org.apache.calcite.linq4j.Linq4j.asEnumerable(new Integer[]}}{{{     0}}}{{);}}{{  return new org.apache.calcite.linq4j.AbstractEnumerable(){}}{{      public org.apache.calcite.linq4j.Enumerator enumerator() {}}{{        return new org.apache.calcite.linq4j.Enumerator(){}}{{            public final org.apache.calcite.linq4j.Enumerator inputEnumerator = _inputEnumerable.enumerator();}}{{            public void reset()}}{{{               inputEnumerator.reset();             }}}{{ }}{{            public boolean moveNext()}}{{{               return inputEnumerator.moveNext();             }}}{{ }}{{            public void close()}}{{{               inputEnumerator.close();             }}}{{ }}{{            public Object current()}}{{{               final java.math.BigDecimal v = $L4J$C$new_java_math_BigDecimal_1_0_;               return org.apache.calcite.runtime.GeoFunctions.ST_MakePoint(v, 1);             }}}{{ }}{{            static final java.math.BigDecimal $L4J$C$new_java_math_BigDecimal_1_0_ = new java.math.BigDecimal(}}{{              "1.0");}}{{          };}}{{      }}}{{ }}{{    };}}{{}}}{{ }}{{ }}{{public Class getElementType()}}{{{   return org.apache.calcite.runtime.GeoFunctions.Geom.class; }}}{{(state=,code=0)}}

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)