November 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2381) Error with virtual procedure inserting into global temporary table

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2381?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2381. ------------------------------------ Resolution: Done fix commited to master, 9.0.x and 8.6.x Required RecordFactory to discover if the TableRecord was a temp table and set the property on the record so the Resolver could successfully ... resolve the SQL. > Error with virtual procedure inserting into global temporary table > ------------------------------------------------------------------ > > Key: TEIIDDES-2381 > URL: https://issues.jboss.org/browse/TEIIDDES-2381 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 8.6 > Reporter: Jan Stastny > > I have a view model (called IPView) with global temporary table (called global_temp_table), then I have virtual procedure in the same model where I try to insert data into the global temporary table. When the Transformation Editor's content is saved, it displays an error under the editor's text area. The error has following message: > ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table > This error does not give the user any hint what went wrong (what he did wrong). -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2384) Visual corruption of dropdowns in import dialogs

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIIDDES-2384: ---------------------------------------- Summary: Visual corruption of dropdowns in import dialogs Key: TEIIDDES-2384 URL: https://issues.jboss.org/browse/TEIIDDES-2384 Project: Teiid Designer Issue Type: Bug Components: Dialogs, Eclipse Integration, Usability Affects Versions: 9.0.1 Environment: Teiid Designer 9.0.1.Beta1-v20141021-1225-B183 JBDS 8.0.0.GA Fedora 20 Reporter: Andrej Šmigala Dropdowns in some of the import dialogs (JDBC import dialog, Teiid Connection import dialog) seem to overlay several entries over each other, which makes selecting with mouse impossible. Selecting with arrow keys is possible, but the items are highlighted in seemingly random order. This issue does not appear anywhere else (at least I haven't been able to find any other examples). Only happens on Linux. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes comments

by Jan Stastny (JIRA)

Jan Stastny created TEIIDDES-2383: ------------------------------------- Summary: Transformation editor removes comments Key: TEIIDDES-2383 URL: https://issues.jboss.org/browse/TEIIDDES-2383 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 8.6, 9.0 Reporter: Jan Stastny When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2382) No error message for query with aggregate function and no group by clause

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2382?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2382: ---------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1161045 > No error message for query with aggregate function and no group by clause > ------------------------------------------------------------------------- > > Key: TEIIDDES-2382 > URL: https://issues.jboss.org/browse/TEIIDDES-2382 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 8.6 > Reporter: Jan Stastny > > In designer when defining a table in view model with following transformation query, bad error message is returned to user. > SELECT cust.id AS customer_id, SUM(ord.amount) AS total_amount > FROM > customers AS cust INNER JOIN orders AS ord > ON cust.id = ord.customer_id > GROUP BY cust.id; > When user forgets to write the GROUP BY clause then error with following message occurs: "ERROR:ERROR". > When I execute similar query via teeid driver then I get very useful message: "Error: Remote org.teiid.api.exception.query.QueryValidatorException: Non-constant, non-aggregate expression cust.id cannot be mixed with aggregate functions and implicit grouping." > It would be very helpful if Teiid designer gave similar message instead of the "ERROR:ERROR" one. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2382) No error message for query with aggregate function and no group by clause

by Jan Stastny (JIRA)

Jan Stastny created TEIIDDES-2382: ------------------------------------- Summary: No error message for query with aggregate function and no group by clause Key: TEIIDDES-2382 URL: https://issues.jboss.org/browse/TEIIDDES-2382 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 8.6 Reporter: Jan Stastny In designer when defining a table in view model with following transformation query, bad error message is returned to user. SELECT cust.id AS customer_id, SUM(ord.amount) AS total_amount FROM customers AS cust INNER JOIN orders AS ord ON cust.id = ord.customer_id GROUP BY cust.id; When user forgets to write the GROUP BY clause then error with following message occurs: "ERROR:ERROR". When I execute similar query via teeid driver then I get very useful message: "Error: Remote org.teiid.api.exception.query.QueryValidatorException: Non-constant, non-aggregate expression cust.id cannot be mixed with aggregate functions and implicit grouping." It would be very helpful if Teiid designer gave similar message instead of the "ERROR:ERROR" one. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2050) Full Temp Table support in Designer

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2050?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2050: ---------------------------------------- TEIIDDES-1794 defines how to handle GLOBAL TEMP Table. For LOCAL/FOREIGN temp tables, the designer needs to support resolving logic when statements like below exist in any procedure block {code} BEGIN CREATE LOCAL TEMPORARY TABLE name ...; CREATE FOREIGN TEMPORARY TABLE name ... ON schema INSERT INTO #name (column, ...) VALUES (value, ...) INSERT INTO #name [(column, ...)] select c1, c2 from t END {code} > Full Temp Table support in Designer > ----------------------------------- > > Key: TEIIDDES-2050 > URL: https://issues.jboss.org/browse/TEIIDDES-2050 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: Future > > > Per TEIIDDES-1794 there are more areas Designer needs to add support for temporary tables: > ... the full array of temp table stuff we currently support is: > * Teiid global temporary table (a virtual entry - which from an engine perspective can be on any model type) > * Teiid temporary table (not a schema entry in the design time metadata, scoped to a session/block) > * Teiid temporary table backed by a physical table (not a schema entry in the design time metadata, scoped to a session/block - the physical table could be a temporary one) > Eventually we would also like to have an ease of use path to simply create a teiid temporary table and have the backing table created on a source automatically - similar to the data shipment join temporary table creation. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2050) Full Temp Table support in Designer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2050?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2050: ---------------------------------------- One option would be to change the global-temp-table boolean property to a enumerated String property, so the user (or UI) would select one of the above options. > Full Temp Table support in Designer > ----------------------------------- > > Key: TEIIDDES-2050 > URL: https://issues.jboss.org/browse/TEIIDDES-2050 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: Future > > > Per TEIIDDES-1794 there are more areas Designer needs to add support for temporary tables: > ... the full array of temp table stuff we currently support is: > * Teiid global temporary table (a virtual entry - which from an engine perspective can be on any model type) > * Teiid temporary table (not a schema entry in the design time metadata, scoped to a session/block) > * Teiid temporary table backed by a physical table (not a schema entry in the design time metadata, scoped to a session/block - the physical table could be a temporary one) > Eventually we would also like to have an ease of use path to simply create a teiid temporary table and have the backing table created on a source automatically - similar to the data shipment join temporary table creation. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2052) 'Mark as Deployable' on a war not working for remote (OpenShift) server

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2052?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2052: ----------------------------------- Fix Version/s: 9.1 (was: 9.0) (was: 8.6.1) > 'Mark as Deployable' on a war not working for remote (OpenShift) server > ----------------------------------------------------------------------- > > Key: TEIIDDES-2052 > URL: https://issues.jboss.org/browse/TEIIDDES-2052 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 8.3.1 > Reporter: Mark Drilling > Assignee: Mark Drilling > Fix For: 9.1 > > > I created a war (using Rest War generator) in Designer and added it to my project. Then to deploy it, I selected it and used the 'Mark as Deployable" action. > This worked fine on my local server (both deploy and undeploy) but then I switched to an OpenShift external server instance (used port-forwarding). > The 'Mark as Deployable' action doesnt work for the Openshift external server. Maybe the action is doing a copy of the war into the deployments folder? > We don't provide the action, but we should either troubleshoot or potentially provide our own action which deploys a war using the admin api. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2381) Error with virtual procedure inserting into global temporary table

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2381?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2381 at 11/4/14 3:51 PM: ----------------------------------------------------------------- [~shawkins] Yes, I see the logic referencing a Table.Type.TemporaryTable. Your docs also describe both "CREATE LOCAL TEMPORARY TABLE* and *CREATE GLOBAL TEMPORARY TABLE*. If there is no difference to the resolver, then the logic in TempMetadataAdapter seems clear enough. Another question.... what is Teiid expecting in the runtime indexes to identify global temp tables? was (Author: blafond): [~shawkins] Yes, I see the logic referencing a Table.Type.TemporaryTable. Your docs also describe both "CREATE LOCAL TEMPORARY TABLE* and *CREATE GLOBAL TEMPORARY TABLE*. If there is no difference to the resolver, then the logic in TempMetadataAdapter seems clear enough. > Error with virtual procedure inserting into global temporary table > ------------------------------------------------------------------ > > Key: TEIIDDES-2381 > URL: https://issues.jboss.org/browse/TEIIDDES-2381 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 8.6 > Reporter: Jan Stastny > > I have a view model (called IPView) with global temporary table (called global_temp_table), then I have virtual procedure in the same model where I try to insert data into the global temporary table. When the Transformation Editor's content is saved, it displays an error under the editor's text area. The error has following message: > ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table > This error does not give the user any hint what went wrong (what he did wrong). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2381) Error with virtual procedure inserting into global temporary table

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2381?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2381: ---------------------------------------- [~shawkins] Yes, I see the logic referencing a Table.Type.TemporaryTable. Your docs also describe both "CREATE LOCAL TEMPORARY TABLE* and *CREATE GLOBAL TEMPORARY TABLE*. If there is no difference to the resolver, then the logic in TempMetadataAdapter seems clear enough. > Error with virtual procedure inserting into global temporary table > ------------------------------------------------------------------ > > Key: TEIIDDES-2381 > URL: https://issues.jboss.org/browse/TEIIDDES-2381 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 8.6 > Reporter: Jan Stastny > > I have a view model (called IPView) with global temporary table (called global_temp_table), then I have virtual procedure in the same model where I try to insert data into the global temporary table. When the Transformation Editor's content is saved, it displays an error under the editor's text area. The error has following message: > ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table > This error does not give the user any hint what went wrong (what he did wrong). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2014