[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2698:
-----------------------------------
Component/s: Dynamic VDBs
Extension Framework
> REST procedure in generated dynamic VDB does not work
> -----------------------------------------------------
>
> Key: TEIIDDES-2698
> URL: https://issues.jboss.org/browse/TEIIDDES-2698
> Project: Teiid Designer
…
[View More]> Issue Type: Bug
> Components: Dynamic VDBs, Extension Framework, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a REST procedure is exported as a dynamic VDB, the resulting autogenrated WAR does not work. This is because the generated DDL does not contain the OPTIONS clause with REST properties, nor does it contain the required SET NAMESPACE statement
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL (note that this also incorporates TEIIDDES-2697):
> {code:sql}
> SET NAMESPACE 'http://teiid.org/rest' AS REST;
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2698:
--------------------------------------
Assignee: Mark Drilling
> REST procedure in generated dynamic VDB does not work
> -----------------------------------------------------
>
> Key: TEIIDDES-2698
> URL: https://issues.jboss.org/browse/TEIIDDES-2698
> Project: Teiid Designer
> Issue Type: Bug
&…
[View More]gt; Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a REST procedure is exported as a dynamic VDB, the resulting autogenrated WAR does not work. This is because the generated DDL does not contain the OPTIONS clause with REST properties, nor does it contain the required SET NAMESPACE statement
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL (note that this also incorporates TEIIDDES-2697):
> {code:sql}
> SET NAMESPACE 'http://teiid.org/rest' AS REST;
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2698:
-----------------------------------
Fix Version/s: 9.2.1
> REST procedure in generated dynamic VDB does not work
> -----------------------------------------------------
>
> Key: TEIIDDES-2698
> URL: https://issues.jboss.org/browse/TEIIDDES-2698
> Project: Teiid Designer
> Issue Type: Bug
> …
[View More] Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a REST procedure is exported as a dynamic VDB, the resulting autogenrated WAR does not work. This is because the generated DDL does not contain the OPTIONS clause with REST properties, nor does it contain the required SET NAMESPACE statement
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL (note that this also incorporates TEIIDDES-2697):
> {code:sql}
> SET NAMESPACE 'http://teiid.org/rest' AS REST;
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2719:
-----------------------------------
Component/s: Dynamic VDBs
Patch Release
(was: VDB & Execution)
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/…
[View More]browse/TEIIDDES-2719
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Fix For: 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2719:
--------------------------------------
Assignee: Barry LaFond
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/browse/TEIIDDES-2719
> Project: Teiid Designer
> …
[View More]Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 4 months