[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