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

Procedure result set not being generated when creating simple CREATE VIRTUAL PROCEDURE from SQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.1
    • 8.1
    • Modeling, Validation
    • None

    Description

      Designer 7.7.x will auto-generated the virtual procedure result set and columns after pasting in the following:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT * FROM PARTS;
      END

      Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and columns are not generated.

      When creating a Web Service Model/Operation from same PARTS source table the resulting Operation will have a resulting OUTPUT (result set) but no output column with XML type

      Attachments

        Activity

          People

            parichar@redhat.com Paul Richardson
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: