Details
-
Bug
-
Resolution: Done
-
Major
-
7.1
-
None
Description
This SQL:
SELECT t.* FROM
(EXEC WeatherData.invoke(action = 'GET', 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
will fail as location-key contains a hyphen. Actually, the only character which is not valid in a name is the period. Please verify with the Teiid server crew, but we should loosen up the validation criteria as appropriate.