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