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

View model transformation with procedure as only source fails validation with The sql transformation does not have a valid source

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.4
    • 7.4
    • Modeling
    • None

    Description

      I was following the Recursive Text E2E test. This calls for creating a relational source model with a procedure (getTextFiles) for use in a view model's transformation. With all this modeled, the transformation fails with the error: The sql transformation does not have a valid source.

      The actual transformation SQL text is:
      SELECT * FROM (EXEC text.getTextFiles('EmpData.txt')) AS f, TEXTTABLE(f.file COLUMNS lastName string, firstName string, middleName string, empId biginteger, department string, annualSalary double, title string, homePhone string, mgrId biginteger, street string, city string, state string, ZipCode string HEADER 3) AS emp

      In previous versions this passed validation. Model project set is attached.

      Attachments

        Issue Links

          Activity

            People

              blafond Barry LaFond
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: