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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 7.3
    • Fix Version/s: 7.3
    • Component/s: Transformations
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  pnittel Paul Nittel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: