[
https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-1614:
-----------------------------------
Description:
Designer 7.7.x will auto-generated the virtual procedure result set and columns after
pasting in the following:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT * FROM PARTS;
END
Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and
columns are not generated.
When creating a Web Service Model/Operation from same PARTS source table the resulting
Operation will have a resulting OUTPUT (result set) but no output column with XML type
was:
Designer 7.7.x will auto-generated the virtual procedure result set and columns after
pasting in the following:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT * FROM PARTS;
END
Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and
columns are not generated.
Procedure result set not being generated when creating simple CREATE
VIRTUAL PROCEDURE from SQL
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-1614
URL:
https://issues.jboss.org/browse/TEIIDDES-1614
Project: Teiid Designer
Issue Type: Bug
Components: Modeling, Validation
Affects Versions: 8.1
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.1
Designer 7.7.x will auto-generated the virtual procedure result set and columns after
pasting in the following:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT * FROM PARTS;
END
Current Designer 8.1 codebase results in valid SQL (no errors) but the result set and
columns are not generated.
When creating a Web Service Model/Operation from same PARTS source table the resulting
Operation will have a resulting OUTPUT (result set) but no output column with XML type
--
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:
http://www.atlassian.com/software/jira