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

"Create Web Service" wizard on a virtual procedure produces invalid SQL in transformation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.4
    • 7.0
    • Transformations
    • None
    • Workaround Exists
    • Hide

      Re-write the transformation to procedural relational syntax.

      Show
      Re-write the transformation to procedural relational syntax.

    Description

      If you use our "Create Web Service" wizard on a virtual procedure the SQL transformation for the Output View is invalid for the current product.

      For example, our wizard produced:
      SELECT
      *
      FROM
      (EXEC TwoStepsFeatureTable.TwoSteps(left_node = left_node)) AS TwoSteps

      so it errors on left_node:
      Resolver Error: Symbol left_node is specified with an unknown group context

      The transformation should be procedural relational instead:
      SELECT * FROM TwoStepsFeatureTable.TwoSteps

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: