December 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2723) Properties lost when importing from dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2723?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2723. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/4f7c160e5a02c5e47... > Properties lost when importing from dynamic VDB > ----------------------------------------------- > > Key: TEIIDDES-2723 > URL: https://issues.jboss.org/browse/TEIIDDES-2723 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: CustomPropertyVdb-vdb.xml > > > When importing a -vdb.xml, the properties are not imported. This includes both properties defined in the vdb root, as well as properties defined in the models (not sure where would those be imported though). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2473) Support multiple metadata tags

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2473?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2473: ----------------------------------- Fix Version/s: 10.1 (was: 9.2.1) > Support multiple metadata tags > ------------------------------ > > Key: TEIIDDES-2473 > URL: https://issues.jboss.org/browse/TEIIDDES-2473 > Project: Teiid Designer > Issue Type: Feature Request > Components: Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Dan Florian > Fix For: 10.1 > > > With TEIID-3372 we allowed metadata tags under a model, rather than relying on comma separated values. Any Designer side logic dealing with the DMR layer will need to be updated to match the new server side logic - see ModelMetaData getSourceMetadataType and getSourceMetadataText -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 months

1
0
0 / 0

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2743: -------------------------------------- Assignee: Barry LaFond > 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 > Fix For: 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)

10 years, 4 months

1
0
0 / 0

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2743: ----------------------------------- Fix Version/s: 9.2.1 > 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 > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Fix For: 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)

10 years, 4 months

1
0
0 / 0

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2743: ----------------------------------- Component/s: Patch Release > 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 > Fix For: 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)

10 years, 4 months

1
0
0 / 0

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2743?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2743. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/be4a9dfe4bc093cb8... > 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 > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > > 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)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2664: ---------------------------------------- On export of dyn. vdbs, added check to add options if they exist for a Result Set. Still waiting for changes in teiid parser and we'll need to add specific options for result sets if Teiid adds them as standard extension properties. > Add Model Extension support for Procedure RESULTS OPTIONS > --------------------------------------------------------- > > Key: TEIIDDES-2664 > URL: https://issues.jboss.org/browse/TEIIDDES-2664 > Project: Teiid Designer > Issue Type: Enhancement > Components: Patch Release, Teiid Integration > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Fix For: 9.2.1 > > > Teiid DDL now supports options for procedure/functions returns clause parameters: > ... RETURNS (options ...) type > ... RETURNS (options ...) TABLE (...) > This was added to Teiid version 8.12 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2589) The model extension definition "relational" found in model is a different version than the one in the registry.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2589?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2589. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/7c6ba99ce24d9c710... > The model extension definition "relational" found in model is a different version than the one in the registry. > --------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2589 > URL: https://issues.jboss.org/browse/TEIIDDES-2589 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.0, 9.0.1, 9.1, 9.0.2 > Reporter: Lukas Mro > Assignee: Barry LaFond > Fix For: 9.2.1 > > > After importing model from TD 8.1.0 to 9.X.X two types of errors occures > 3 types of errors occures: > 1. The model extension definition "rest" found in model is not registered in workspace -> this one can be autofix > 2. The model extension definition "relational" found in model is a different version than the one in the registry -> This one do not have fix > 3. java.lang.StringIndexOutOfBoundsException: String index out of range: 1 > -> this one do not have fix > I`m not sure what should i send you, AMA :) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2745. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/7c6ba99ce24d9c710... > Extension properties not imported from dynamic VDB > -------------------------------------------------- > > Key: TEIIDDES-2745 > URL: https://issues.jboss.org/browse/TEIIDDES-2745 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Patch Release > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > When importing a dynamic VDB containing models with extension properties, the properties are not imported. > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="MatViewsVdb" version="1"> > <description>For testing of materialized views</description> > > <model name="Source"> > <source name="Source" translator-name="h2-override" > connection-jndi-name="java:/mat-views-ds" /> > <metadata type="DDL"><![CDATA[ > > CREATE FOREIGN TABLE customers ( > id integer, > name string(4000), > address string(4000), > CONSTRAINT PK_ID PRIMARY KEY(id) > ) OPTIONS(NAMEINSOURCE 'customer') > > CREATE FOREIGN TABLE orders ( > id integer, > customer_id integer, > amount integer, > CONSTRAINT PK_ID PRIMARY KEY(id), > CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id) > ) OPTIONS(NAMEINSOURCE 'order') > ]]> > </metadata> > </model> > >  > <model name="ViewModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW internal_short_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')' > ) > AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > > CREATE VIEW internal_long_ttl ( > customer_id integer PRIMARY KEY, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE') > AS /*+ cache(ttl:1000 updatable)*/ SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS', > "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION', > "teiid_rel:MATVIEW_TTL" 2000) > AS SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="h2-override" type="h2"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2622) DDL importer does not properly set Materialized table options

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2622?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2622. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/7c6ba99ce24d9c710... > DDL importer does not properly set Materialized table options > ------------------------------------------------------------- > > Key: TEIIDDES-2622 > URL: https://issues.jboss.org/browse/TEIIDDES-2622 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Import/Export, Patch Release > Affects Versions: 9.0.1, 9.1 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > Importing a DDL similar to the one [here|https://docs.jboss.org/author/display/teiid810final/External+Materia...], the Materialized property of the view table is set, but the Materialized Table property is not. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 4 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 December 2015