October 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2939) Add module dependencies to support JDG 7.1

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2939?page=com.atlassian.jira.plu... ] Van Halbert moved TEIID-4522 to TEIIDDES-2939: ---------------------------------------------- Project: Teiid Designer (was: Teiid) Key: TEIIDDES-2939 (was: TEIID-4522) Component/s: Modeling (was: Misc. Connectors) Affects Version/s: (was: 8.12.7.6_3) Fix Version/s: 10.0.3 (was: 8.12.7.6_3) > Add module dependencies to support JDG 7.1 > ------------------------------------------ > > Key: TEIIDDES-2939 > URL: https://issues.jboss.org/browse/TEIIDDES-2939 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 10.0.3 > > > The JDG 7.1 modules need to be added as dependencies in the infinispan translator and connector module.xml files. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2871) Data roles editor problem

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2871?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2871. ---------------------------------- > Data roles editor problem > ------------------------- > > Key: TEIIDDES-2871 > URL: https://issues.jboss.org/browse/TEIIDDES-2871 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Changes in data roles are not always acknowledged by TD. > See steps to reproduce and attached video. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2871) Data roles editor problem

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2871?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2871: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Data roles editor problem > ------------------------- > > Key: TEIIDDES-2871 > URL: https://issues.jboss.org/browse/TEIIDDES-2871 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Changes in data roles are not always acknowledged by TD. > See steps to reproduce and attached video. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2873) Data roles - row filtering disappearing

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2873?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2873: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Data roles - row filtering disappearing > ---------------------------------------- > > Key: TEIIDDES-2873 > URL: https://issues.jboss.org/browse/TEIIDDES-2873 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Sometimes when I am trying to define row filtering on table for a specific data role, it disappears after I save the model. > For exact steps to reproduce see attached video. > https://dl.dropboxusercontent.com/u/21733588/dataroles1.mov > I tested with the latest TD build. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2873) Data roles - row filtering disappearing

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2873?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2873. ---------------------------------- > Data roles - row filtering disappearing > ---------------------------------------- > > Key: TEIIDDES-2873 > URL: https://issues.jboss.org/browse/TEIIDDES-2873 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Sometimes when I am trying to define row filtering on table for a specific data role, it disappears after I save the model. > For exact steps to reproduce see attached video. > https://dl.dropboxusercontent.com/u/21733588/dataroles1.mov > I tested with the latest TD build. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2411) Add support for single line -- comments

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2411?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2411: ----------------------------------- Attachment: paint.png > Add support for single line -- comments > --------------------------------------- > > Key: TEIIDDES-2411 > URL: https://issues.jboss.org/browse/TEIIDDES-2411 > Project: Teiid Designer > Issue Type: Feature Request > Components: Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: commentProject.zip, paint.png > > > As seen in TEIID-3073, we should have support for -- comments. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2411) Add support for single line -- comments

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2411?page=com.atlassian.jira.plu... ] Matej Kralik reopened TEIIDDES-2411: ------------------------------------ The behavior is same as in my previous comment. For example, when I import DDL with comments (project and ddl from [TEIIDDES-2911|https://issues.jboss.org/browse/TEIIDDES-2911]), the comments are set probably correctly (because when I want to export this model which I had imported, exported DDL contains all comments for right tables) but in the transformation editor is shown only one comment for each table. I uploaded screenshot (paint.png) > Add support for single line -- comments > --------------------------------------- > > Key: TEIIDDES-2411 > URL: https://issues.jboss.org/browse/TEIIDDES-2411 > Project: Teiid Designer > Issue Type: Feature Request > Components: Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: commentProject.zip, paint.png > > > As seen in TEIID-3073, we should have support for -- comments. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2930: ---------------------------------------- [~mkralik] I tested again today and the generated vdb.xml shows materialized table reference properly sets the path. > Dynamic VDB should contain full path to the materialized table > -------------------------------------------------------------- > > Key: TEIIDDES-2930 > URL: https://issues.jboss.org/browse/TEIIDDES-2930 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: jdgCustomer.zip, screenshot1.png, screenshotProp.png > > > I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error: > TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model. > I noticed that in the dynamicVDB in the CustomerViewMat model is: > {code:java} > OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ... > {code} > I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache) > When I set full path, vdb was deployed sucessfully > {code:java} > OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ... > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2749. ---------------------------------- > Cache hint removed from transformation when importing dynamic VDB > ----------------------------------------------------------------- > > Key: TEIIDDES-2749 > URL: https://issues.jboss.org/browse/TEIIDDES-2749 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > When importing a dynamic VDB, cache hints are removed from the transformation. > {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; > ]]> > </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)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2749: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Cache hint removed from transformation when importing dynamic VDB > ----------------------------------------------------------------- > > Key: TEIIDDES-2749 > URL: https://issues.jboss.org/browse/TEIIDDES-2749 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > When importing a dynamic VDB, cache hints are removed from the transformation. > {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; > ]]> > </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)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2016