March 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2798?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2798: -------------------------------------- Assignee: Barry LaFond > Dynamic VDB can not be generated - view model with procedure > ------------------------------------------------------------ > > Key: TEIIDDES-2798 > URL: https://issues.jboss.org/browse/TEIIDDES-2798 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 10.0 > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Blocker > Fix For: 10.0.1 > > Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png > > > VDB from project that is attached can not be exported to dynamic VDB. > This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2798?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2798: ----------------------------------- Priority: Blocker (was: Major) > Dynamic VDB can not be generated - view model with procedure > ------------------------------------------------------------ > > Key: TEIIDDES-2798 > URL: https://issues.jboss.org/browse/TEIIDDES-2798 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 10.0 > Reporter: Matus Makovy > Priority: Blocker > Fix For: 10.0.1 > > Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png > > > VDB from project that is attached can not be exported to dynamic VDB. > This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2798?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2798: ----------------------------------- Component/s: Import/Export Patch Release > Dynamic VDB can not be generated - view model with procedure > ------------------------------------------------------------ > > Key: TEIIDDES-2798 > URL: https://issues.jboss.org/browse/TEIIDDES-2798 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 10.0 > Reporter: Matus Makovy > Fix For: 10.0.1 > > Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png > > > VDB from project that is attached can not be exported to dynamic VDB. > This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2798?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2798: ----------------------------------- Fix Version/s: 10.0.1 > Dynamic VDB can not be generated - view model with procedure > ------------------------------------------------------------ > > Key: TEIIDDES-2798 > URL: https://issues.jboss.org/browse/TEIIDDES-2798 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0 > Reporter: Matus Makovy > Fix For: 10.0.1 > > Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png > > > VDB from project that is attached can not be exported to dynamic VDB. > This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2743) Return parameter not created when importing UDF from dynamic VDB

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2743. ---------------------------------- > Return parameter not created when importing UDF from dynamic VDB > ---------------------------------------------------------------- > > Key: TEIIDDES-2743 > URL: https://issues.jboss.org/browse/TEIIDDES-2743 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Patch Release > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0.1, 9.2.1 > > > When importing a dynamic VDB containing a UDF, the imported UDF is missing the RETURN parameter. This parameter is not specified as parameter in the DDL, but rather in the RETURNS clause. > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <vdb name="UdfProcedureVdb" version="1"> > <description /> > <property name="validationDateTime" value="Tue Nov 10 13:18:14 CET 2015" /> > <property name="validationVersion" value="8.7.1" /> > <model name="ProcedureModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIRTUAL FUNCTION udfConcatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') > ]]></metadata> > </model> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2743) Return parameter not created when importing UDF from dynamic VDB

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2743: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.0.Beta (was: ) > Return parameter not created when importing UDF from dynamic VDB > ---------------------------------------------------------------- > > Key: TEIIDDES-2743 > URL: https://issues.jboss.org/browse/TEIIDDES-2743 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Patch Release > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0.1, 9.2.1 > > > When importing a dynamic VDB containing a UDF, the imported UDF is missing the RETURN parameter. This parameter is not specified as parameter in the DDL, but rather in the RETURNS clause. > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <vdb name="UdfProcedureVdb" version="1"> > <description /> > <property name="validationDateTime" value="Tue Nov 10 13:18:14 CET 2015" /> > <property name="validationVersion" value="8.7.1" /> > <model name="ProcedureModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIRTUAL FUNCTION udfConcatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') > ]]></metadata> > </model> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ] Matus Makovy edited comment on TEIIDDES-2698 at 3/1/16 9:53 AM: ---------------------------------------------------------------- This cannot be verified because of TEIIDDES-2798 was (Author: mmakovy): This can not be verified because of TEIIDDES-2798 > 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: Dynamic VDBs, Extension Framework, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 10.0.1, 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)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2697: ----------------------------------- Labels: (was: release_notes verified_jbdsis-9.0.0.Beta) > 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, 10.0.1, 9.2.1 > > 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)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2698) REST procedure in generated dynamic VDB does not work

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2698?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2698: ------------------------------------ This can not be verified because of TEIIDDES-2798 > 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: Dynamic VDBs, Extension Framework, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 10.0.1, 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)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2697: ------------------------------------ Reopening this issue, since we ran into TEIIDDES-2798 with latest TD 10.0.0.Beta3 build. > 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 > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 9.2, 10.0.1, 9.2.1 > > 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)

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues March 2016