[teiid-issues] [JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

Tom Johnston (JIRA) issues at jboss.org
Tue Jul 12 12:02:00 EDT 2016


     [ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom Johnston updated TEIID-4331:
--------------------------------
    Steps to Reproduce: 
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

  was:
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(Sybase_PostFixProfile.VERTICAL_OBSTRUCTION.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



> Use of st_geomfromText wrapped around a UDF fails.
> --------------------------------------------------
>
>                 Key: TEIID-4331
>                 URL: https://issues.jboss.org/browse/TEIID-4331
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Tom Johnston
>            Assignee: Steven Hawkins
>         Attachments: gis-1.0.0.jar
>
>




--
This message was sent by Atlassian JIRA
(v6.4.11#64026)


More information about the teiid-issues mailing list