]
Barry LaFond reassigned TEIIDDES-1566:
--------------------------------------
Assignee: Barry LaFond (was: Ted Jones)
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}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: