[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1098) Procedure parameter name refactoring issues

Procedure parameter name refactoring issues ------------------------------------------- Key: TEIIDDES-1098 URL: https://issues.jboss.org/browse/TEIIDDES-1098 Project: Teiid Designer Issue Type: Bug Components: Modeling Affects Versions: 7.4.2 Reporter: Steven Hawkins Assignee: Barry LaFond Priority: Minor Fix For: 7.7 I encountered a couple of issues when refactoring a procedure parameter name. 1. The procedure transformation sql is not updated with the new name. For example given a procedure with a parameter param and a definition that just returns that value: CREATE VIRTUAL PROCEDURE BEGIN SELECT param AS foo; END refactoring to param1 leaves the select as "select param as foo" rather than updating to select param1 as foo. Note that if this is implemented, then aliases may need to be added to, e.g. "select param" would become "select param1 as param". There is existing logic in the Teiid ExpressionMappingVisitor to handle that. 2. If you undo the refactoring of the name, then even after a save and rebuild the model is still marked with an error. I had to edit the already valid SQL to clear the error.