Refactoring a source model left transformation with mix of old and new model names ---------------------------------------------------------------------------------- Key: TEIIDDES-817 URL: https://issues.jboss.org/browse/TEIIDDES-817 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.3 Reporter: Paul Nittel Attachments: RefactorIsAWord.zip 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.

Refactoring a source model left transformation with mix of old and new model names ---------------------------------------------------------------------------------- Key: TEIIDDES-817 URL: https://issues.jboss.org/browse/TEIIDDES-817 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.3 Reporter: Paul Nittel Priority: Blocker Attachments: RefactorIsAWord.zip, RefactorRename_MPS.zip 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.

Refactoring a source model left transformation with mix of old and new model names ---------------------------------------------------------------------------------- Key: TEIIDDES-817 URL: https://issues.jboss.org/browse/TEIIDDES-817 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.3 Reporter: Paul Nittel Assignee: Barry LaFond Priority: Blocker Fix For: 7.3 Attachments: RefactorIsAWord.zip, RefactorRename_MPS.zip 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.

Refactoring a source model left transformation with mix of old and new model names ---------------------------------------------------------------------------------- Key: TEIIDDES-817 URL: https://issues.jboss.org/browse/TEIIDDES-817 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.3 Reporter: Paul Nittel Assignee: Barry LaFond Priority: Blocker Fix For: 7.3 Attachments: org.teiid.designer.mapping.patch, org.teiid.designer.transformation.patch, RefactorIsAWord.zip, RefactorRename_MPS.zip 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.

Refactoring a source model left transformation with mix of old and new model names ---------------------------------------------------------------------------------- Key: TEIIDDES-817 URL: https://issues.jboss.org/browse/TEIIDDES-817 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.3 Reporter: Paul Nittel Assignee: Barry LaFond Priority: Blocker Fix For: 7.3 Attachments: org.teiid.designer.mapping.patch, org.teiid.designer.transformation.patch, RefactorIsAWord.zip, RefactorRename_MPS.zip 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.