[
https://issues.jboss.org/browse/TEIIDDES-1614?page=com.atlassian.jira.plu...
]
Paul Richardson commented on TEIIDDES-1614:
-------------------------------------------
The cause of this is the setting of the CreateProcedureCommand's projected symbols
collection as empty rather than null. The problem is 2 pronged:
a) New Teiid code in the 8.2 release sets it to empty
b) Designer's TransformValidator sets it to empty due to the 7.7/8.2 migration
A fix for the first has been added to Teiid's 8.3 codestream, see [this
commit|https://github.com/Teiid-Designer/teiid/commit/ddbe94c61b3432fcc7f...]
A fix for the second is more problematic since the project symbols added from the
TransformValidator come from the EObject side of Designer. Thus, some method needs to pass
them in. This is achieved by adding a postResolveCommand method to the IQueryResolver spi
interface and accompanying implementations.
In the 7.7.x implementation of the IQueryResolver, the original if statement can be
restored to its original state and should function correctly, according to the original
fix
added due to [
TEIIDES-624|https://issues.jboss.org/browse/TEIIDDES-624].
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