[
https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-1614:
------------------------------------------
What is the difference between the resultSetColumns and
projectSymbols collections?
Projected columns for procedures may also include out/inout/return parameters.
If the 2 collections are interchangeable why there are 2 collections?
They are not interchangable.
Why in 7.7 did the projectedSymbols get populated with the contents
of resultSetColumns and yet in 8.2+ this is no longer the case?
The old code was problematic in several ways. First it stored the entire "results
command" on the resolved create, which was not necessary and led to clone and
improper usage later. Second it didn't properly differentiate between projected
columns and result set columns, which is needed in virtual procedure invocation to make
parameter assignments based upon out/inout/return values. Third the code in general did
not properly account for the case where there is no result set defined in the metadata -
which is somewhat the crux of this issue. Designer is giving us metadata for the
procedure that is entirely valid - no result set and no parameters and asking us to
resolve the procedure - and yet also wants to know the possible result set columns.
The inclusion of the 'inferProcedureResultSetColumns' is a
workaround for designer to get back the columns so is any of this not required by teiid
anymore?
I'm not sure what that means. Could you elaborate?
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