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

Dynamic VDB Generation - Problem with DDL generated for procedure

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 9.0.4
    • 9.2
    • None
    • None

    Description

      I have a VDB that was created for consumption of REST Web Service.
      There is a procedure named getProgrammes(). DDL generated for dynamic VDB is:

      CREATE VIRTUAL PROCEDURE getProgrammes ()
      AS
      CREATE VIRTUAL PROCEDURE
      BEGIN
      DECLARE STRING VARIABLES.qp = '';
      SELECT
      A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title
      FROM
      (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A;
      END;

      Obviously, there is one extra "CREATE VIRTUAL PROCEDURE".
      Even after fixing this issue there is another error:

      VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel

      "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL

      Attachments

        Issue Links

          Activity

            People

              blafond Barry LaFond
              mmakovy@redhat.com Matus Makovy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: