[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2697:
----------------------------------------
master: https://github.com/Teiid-Designer/teiid-designer/commit/eed0164d20e88a523...
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2697
> URL: https://issues.jboss.org/browse/TEIIDDES-2697
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> 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:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 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)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2697.
------------------------------------
Resolution: Done
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2697
> URL: https://issues.jboss.org/browse/TEIIDDES-2697
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> 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:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 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)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2700) DDL Export logic does not add non-relational extension properties to the DDL OPTIONS() clause
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2700?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2700:
-----------------------------------
Description:
Trying to Export the attached salesforce XMI model, the salesforce extension properties are not included in the OPTIONS() clause.
TeiidModelToDdlGenerator.getTableOptions() method is only adding standard relational properties and not looking via the extension assistant framework.
May need to add a method on the assistant API like *protected Properties getTeiidDdlOptions(BaseTable table)* which would make it clear what the methed returned
> DDL Export logic does not add non-relational extension properties to the DDL OPTIONS() clause
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2700
> URL: https://issues.jboss.org/browse/TEIIDDES-2700
> Project: Teiid Designer
> Issue Type: Bug
> Reporter: Barry LaFond
>
> Trying to Export the attached salesforce XMI model, the salesforce extension properties are not included in the OPTIONS() clause.
> TeiidModelToDdlGenerator.getTableOptions() method is only adding standard relational properties and not looking via the extension assistant framework.
> May need to add a method on the assistant API like *protected Properties getTeiidDdlOptions(BaseTable table)* which would make it clear what the methed returned
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2697:
--------------------------------------
Assignee: Barry LaFond
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2697
> URL: https://issues.jboss.org/browse/TEIIDDES-2697
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> 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:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 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)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2697:
-----------------------------------
Fix Version/s: 9.2
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2697
> URL: https://issues.jboss.org/browse/TEIIDDES-2697
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> 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:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 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)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2698) REST procedure in genrated dynamic VDB does not work
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2698:
-------------------------------------
Description:
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}
was:
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, not 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}
> REST procedure in genrated dynamic VDB does not work
> ----------------------------------------------------
>
> Key: TEIIDDES-2698
> URL: https://issues.jboss.org/browse/TEIIDDES-2698
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> 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)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2698:
-------------------------------------
Summary: REST procedure in generated dynamic VDB does not work (was: REST procedure in genrated dynamic VDB does not work)
> 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
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> 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)
10 years, 6 months