[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1566) Create Web Service On procedure generates invalid sql

Create Web Service On procedure generates invalid sql ----------------------------------------------------- Key: TEIIDDES-1566 URL: https://issues.jboss.org/browse/TEIIDDES-1566 Project: Teiid Designer Issue Type: Bug Components: Web Services Support Affects Versions: 7.4.2 Environment: Windows 7 Reporter: Michael Conner Assignee: Barry LaFond Priority: Minor Fix For: 8.1 # I select on a procedure, {{Rsw_CustomerUnitProc}}, whose result is {{Rsw_CustomerUnitResult}}. # Choose Modeling > Create Web Service # Enter in the appropriate info in the web service, including {{Rsw_CustomerUnit_Output}} for the Output Schema Model. The generated code for the output Model Transformation Editor is: {code} SELECT * FROM Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult {code} And there is an error: {{ERROR: Group does not exist: Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult}} Removing the Result seems to fix the problem: {code} SELECT * FROM Procedures.Rsw_CustomerUnitProc {code}