[
https://issues.jboss.org/browse/TEIIDDES-1811?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-1811 at 7/30/13 5:26 PM:
-----------------------------------------------------------------
1) if procedure is defined as Function == TRUE it'll be interpreted as a
pushdown/source function. The current data tools jdbc metadata does not have a
"folder" for these types of procedures.
2) Create a simple procedure and the procedure was viewable in Data Tools explorer (Stored
Procedure) but did not see parameters
* Generated the DDL for that procedure in datatools explorer and it appeared to know about
the parameters:
{code:xml}
--<ScriptOptions statementTerminator=";"/>
CREATE PROCEDURE PushdownFunction (
INOUT inParam VARCHAR(4000),
IN returnParam VARCHAR(4000))
NOT DETERMINISTIC
NO_SQL;
{code}
was (Author: blafond):
1) if procedure is defined as Function == TRUE it'll be interpreted as a
pushdown/source function. The current data tools jdbc metadata does not have a
"folder" for these types of procedures.
2) Create a simple procedure and the procedure was viewable in Data Tools explorer but did
not see parameters
* Generated the DDL for that procedure in datatools explorer and it appeared to know about
the parameters:
{code:xml}
--<ScriptOptions statementTerminator=";"/>
CREATE PROCEDURE PushdownFunction (
INOUT inParam VARCHAR(4000),
IN returnParam VARCHAR(4000))
NOT DETERMINISTIC
NO_SQL;
{code}
Can't import Procedure parameters to source model in Teiid
Designer
-------------------------------------------------------------------
Key: TEIIDDES-1811
URL:
https://issues.jboss.org/browse/TEIIDDES-1811
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.1
Environment: Windows, eclipse JUNO, Teiid Designer 8.2 alpha1
Reporter: Jing Li
Priority: Critical
Fix For: 8.2
Usually if we have some changes in source VDB, after we update the source model in
designer, we will see the changes.
But for procedure, if we add a new procedure in source VDB, after update SM, we only can
see the procedure, but can't see the paramenters of that procedure. We have to
manually add them.
In this way, in the future, every time when we update our SM, our procedures parameters
will be gone, we have to add them manually.
According to Ramesh -- "That sounds like Designer bug to me. You should log a JIRA
with Teiid Designer."
Thanks.
--
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