[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word

Error Generating REST Transformation with Teiid Reserved Word ------------------------------------------------------------- Key: TEIIDDES-2287 URL: https://issues.jboss.org/browse/TEIIDDES-2287 Project: Teiid Designer Issue Type: Bug Security Level: Public(Everyone can see) Components: Transformations Affects Versions: 8.6 Reporter: Ted Jones Assignee: Ted Jones Fix For: 8.7, 8.6.1 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