Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2287

Error Generating REST Transformation with Teiid Reserved Word

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.6.1
    • 8.6
    • Transformations
    • 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

            rhn-engineering-tejones Edwin Jones
            rhn-engineering-tejones Edwin Jones
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: