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

Refactoring a source model left transformation with mix of old and new model names

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.3
    • 7.3
    • Transformations
    • None

    Description

      I created a project containing a textfile model, a view model (EatsText) which depends on the textfile model. I then stacked another model (UsesText) on top and added a concat sequence to make a fullname. Saved, executed and it looked good.

      Then, I refactored EatsTest to Employees and got a validation error in UsesText. When I looked at the transformation, here's what I found:

      SELECT
      EatsText.et.lastName, Employees.et.firstName, Employees.et.middleName, CONCAT2(EatsText.et.lastName, CONCAT2(', ', CONCAT2(EatsText.et.firstName, CONCAT2(' ', LEFT(EatsText.et.middleName, 1))))) AS FullName, Employees.et.empId, Employees.et.department, Employees.et.annualSalary, Employees.et.title, Employees.et.homePhone, Employees.et.mgrId, Employees.et.street, Employees.et.city, Employees.et.state, Employees.et.ZipCode
      FROM
      EatsText.et

      It has both the old and refactored names in it. Oddly, the SELECT contains both--I could see where the SELECT could be right and the FROM wrong.

      Attachments

        1. org.teiid.designer.mapping.patch
          4 kB
          Barry LaFond
        2. org.teiid.designer.transformation.patch
          7 kB
          Barry LaFond

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: