October 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2699) Issues with Dynamic VDB import/export

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2699?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2699: ---------------------------------------- There are probably several constructs in Teiid BNF that Designer does not yet support. Not yet logged in specific JIRAS 1) GLOBAL TEMP TABLE 2) OPTIONS() clauses not being read/written for all statements (see CREATE PROCEDURE's RETURNS clause: https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...). Note that Designer's Model Extension framework may not be able to import (apply) un-registered extension properties. > Issues with Dynamic VDB import/export > ------------------------------------- > > Key: TEIIDDES-2699 > URL: https://issues.jboss.org/browse/TEIIDDES-2699 > Project: Teiid Designer > Issue Type: Task > Components: VDB & Execution > Reporter: Andrej Šmigala > > Tracking jira for all issues with dynamic VDB import and export -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2700) DDL Export logic does not add non-relational extension properties to the DDL OPTIONS() clause

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2700: -------------------------------------- Summary: 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 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2699) Issues with Dynamic VDB import/export

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIIDDES-2699: ---------------------------------------- Summary: Issues with Dynamic VDB import/export Key: TEIIDDES-2699 URL: https://issues.jboss.org/browse/TEIIDDES-2699 Project: Teiid Designer Issue Type: Task Components: VDB & Execution Reporter: Andrej Šmigala Tracking jira for all issues with dynamic VDB import and export -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2015