Details
-
Bug
-
Resolution: Done
-
Major
-
7.1
-
None
Description
I imported the metadata for the INVOKE function from the weather example VDB. When I used the function in a transformation (see below), there was a validation error. Steve Hawkins noted the type of the result procedure parameter was "object" and should be "SQLXML". (Turns out that "SQLXML" is "XMLLiteral" in current Designer parlance. Perhaps that should be changed... Ask Steve H.)
After several attempts to validate the SQL, it finally validated. (And another Jira is on the way.)
SELECT
t.*
FROM
(EXEC Wx_Teiid.invoke(binding = null, action = 'GET', request = null, endpoint = QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon, 'time-series' AS product, '2004-01-01T00:00:00' AS "begin", '2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint' AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS location_key string, lattitude string PATH 'point/@latitude', longitude string PATH 'point/@longitude') AS t
Attachments
Issue Links
- blocks
-
JBIDE-6367 Teiid Designer
- Closed
- is related to
-
TEIIDDES-72 Fix JDBC Importer to import CLOB as CLOB rather than string
- Closed