-
Bug
-
Resolution: Done
-
Major
-
8.6
-
None
The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column.
BEGIN
DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q);
SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A;
END
The word output should be in double quotes: BEGIN
DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q);
SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A;
END