[
https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu...
]
Paul Richardson commented on TEIIDDES-1614:
-------------------------------------------
Hi Steve,
-[TEIID-2421|https://issues.jboss.org/browse/TEIID-2421]- does not fully solve the
problem. The variable 'inferProcedureResultSetColumns' correctly nullifies the
resultSetColumns collection and the value 'xml' correctly gets added. However, at
no point is the 'xml' value added to the projectedSymbols collection as it was
done in 7.7 (see the setProjectedSymbols line from my last comment). Thus, projectSymbols
remains empty.
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
Attachments: DynamicSQLMPS.zip
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