Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3477

Geospatial function (ST_MakePoint) with integer parameter fails

    XMLWordPrintableJSON

    Details

      Description

      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)
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                donnyzone Feng Zhu
                Reporter:
                kirilm Kirils Mensikovs
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h