Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4331

Use of st_geomfromText wrapped around a UDF fails.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.1
    • 8.12.x
    • Query Engine
    • None
    • Hide

      I have a UDF that returns a POINT
      if I call st_geomfromText like such
      st_geomfromText(ST_MakePoint( longitude,latitude))

      It fails with :
      10:47:31,011 WARN [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue813) TEIID30020 Processing exception for request 8nEl2/1mNvmP.18 'TEIID30328 Unable to evaluate st_geomfromText(ST_MakePoint(Longitude, Latitude)): TEIID30384 Error while evaluating function st_geomfromtext'. Originally ExpressionEvaluationException GeometryUtils.java:139. Enable more detailed logging to see the entire stacktrace.
      ErrorCode: 0..
      SQLState: 50000
      ErrorCode: 0

      however, if I try st_geomfromText( concatenated with the return of St_MakePoint) it works when hard-coded.

      It seems that the wrapping functions with st_geomfromText is a problem?

      I've attached the jar gis-1.00 which is referenced by the St_MakePoint UDF

      Show
      I have a UDF that returns a POINT if I call st_geomfromText like such st_geomfromText(ST_MakePoint( longitude,latitude)) It fails with : 10:47:31,011 WARN [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue813) TEIID30020 Processing exception for request 8nEl2/1mNvmP.18 'TEIID30328 Unable to evaluate st_geomfromText(ST_MakePoint(Longitude, Latitude)): TEIID30384 Error while evaluating function st_geomfromtext'. Originally ExpressionEvaluationException GeometryUtils.java:139. Enable more detailed logging to see the entire stacktrace. ErrorCode: 0.. SQLState: 50000 ErrorCode: 0 however, if I try st_geomfromText( concatenated with the return of St_MakePoint) it works when hard-coded. It seems that the wrapping functions with st_geomfromText is a problem? I've attached the jar gis-1.00 which is referenced by the St_MakePoint UDF

    Attachments

      Activity

        People

          rhn-engineering-shawkins Steven Hawkins
          tljohnst@gmail.com thomas johnston (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          3 Start watching this issue

          Dates

            Created:
            Updated:
            Resolved: