May 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4211) Wrong rewriting of CTEs when pushed down to PostgreSQL

by Salvatore R (JIRA)

Salvatore R created TEIID-4211: ---------------------------------- Summary: Wrong rewriting of CTEs when pushed down to PostgreSQL Key: TEIID-4211 URL: https://issues.jboss.org/browse/TEIID-4211 Project: Teiid Issue Type: Bug Affects Versions: 8.13.4 Reporter: Salvatore R Assignee: Steven Hawkins Running the following query: {code:sql} WITH cte1 as (SELECT * from pg.test_a), cte2 as (select * from cte1), cte3 as (select * from cte1) SELECT * FROM cte2 join cte3 on cte2.a=cte3.a {code} where pg.test_a is a table defined in PostgreSQL, this exception is thrown: {code:sql} 19:42:22,287 WARN [org.teiid.CONNECTOR] (Worker20_QueryProcessorQueue228) ezaCNEtY3C+P Connector worker process failed for atomic-request=ezaCNEtY3C+P.121.3.48: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH cte1 (a, b) AS (SELECT g_0."a", g_0."b" FROM "public"."test_a" AS g_0), cte1 (a, b) AS (SELECT g_0."a", g_0."b" FROM "public"."test_a" AS g_0), cte2 (a,b) AS (SELECT g_0.a, g_0.b FROM cte1 AS g_0), cte3 (a, b) AS (SELECT g_0.a, g_0.b FROM cte1 AS g_0) SELECT g_1.a, g_1.b, g_0.a, g_0.b FROM cte2 AS g_0, cte3 AS g_1 WHERE g_0.a = g_1.a] at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:359) at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy56.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: WITH query name "cte1" specified more than once Position: 78 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) ... 17 more {code} I am not sure if the problem below might be also related, but an exception is thrown by running the following query with nested CTEs: {code:sql} WITH cte1 as (SELECT 1 as a) ,cte3 as (with cte3_1 as (select cte1.a from cte1 join pg.test_a t1 on cte1.a=t1.a) select * from cte3_1) SELECT * FROM cte3;; {code} The exception is: {code:sql} 20:00:37,731 WARN [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue239) ezaCNEtY3C+P TEIID30020 Processing exception for request ezaCNEtY3C+P.125 'TEIID30226 Temporary table "cte1" does not exist.'. Originally QueryProcessingException TempTableStore.java:564. Enable more detailed logging to see the entire stacktrace. {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4208) Increase plan parallelism

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4208?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4208: --------------------------------------- Progress on this has been slow. There are two approaches - either use a multi-threaded approach to additional execution points in the plan that are isolated from overall plan processing or try to insert general parallel processing at branch points. The most logical place for isolated parallelization would be during sorting - ideally both the initial and the merge phase (with the plan structure guiding when the parallelization is attempted). Inserting at branch points is a little more difficult in that a similar amount of plan analysis needs done and we have to update at least the commandcontext to have more thread-safe logic. Initial testing with either has not been all that positive. It may also be worth some time to just do more issues like TEIID-4210 (such as sort / dependent join latency) as well. > Increase plan parallelism > ------------------------- > > Key: TEIID-4208 > URL: https://issues.jboss.org/browse/TEIID-4208 > Project: Teiid > Issue Type: Sub-task > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.x > > > Increased parallelism within the plan, which includes parallelization of source queries via partitioning beyond multi-source and parallelizing the execution of union branches. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] Juraj Duráni reopened TEIID-4044: --------------------------------- Ramesh, sorry. It seems I have a bad day. I have created a new test for TEIID-4064. The new test passes. Test for TEIID-4044 is still failing. Therefore, my final decision (at leas I hope so:)) is that TEIID-4044 is not fixed and TEIID-4064 is fixed. > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] Juraj Duráni closed TEIID-4044. ------------------------------- Resolution: Duplicate Issue Sorry, closing again. TEIID-4064 seems to be not resolved as well. I am sorry for this situation. > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4044: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1316476|https://bugzilla.redhat.com/show_bug.cgi?id=1316476] from CLOSED to ASSIGNED > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4210) Allow limits to apply to the final sort pass

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4210?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4210. ----------------------------------- Resolution: Done The commit allows ... order by ... limit x to effectively be combined so that we only process what is needed of the final sort. > Allow limits to apply to the final sort pass > -------------------------------------------- > > Key: TEIID-4210 > URL: https://issues.jboss.org/browse/TEIID-4210 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > A left over todo was to support allowing the affect of limiting to short circuit the last sort phase. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] Juraj Duráni reopened TEIID-4044: --------------------------------- This is not resolved in ER3. Note that TEIID-4064 is resolved, but this one not. So I expected this to be no more duplicate of TEIID-4064. > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4035) Parameter alias without value returns http status code 500

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4035?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4035: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1316466|https://bugzilla.redhat.com/show_bug.cgi?id=1316466] from ON_QA to ASSIGNED > Parameter alias without value returns http status code 500 > ---------------------------------------------------------- > > Key: TEIID-4035 > URL: https://issues.jboss.org/browse/TEIID-4035 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* OData Library: An exception without message text was thrown. > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4210) Allow limits to apply to the final sort pass

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4210: ------------------------------------- Summary: Allow limits to apply to the final sort pass Key: TEIID-4210 URL: https://issues.jboss.org/browse/TEIID-4210 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0 A left over todo was to support allowing the affect of limiting to short circuit the last sort phase. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4209) Primary key import fails with OSIsoft PI translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4209?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4209: ---------------------------------- Component/s: Misc. Connectors > Primary key import fails with OSIsoft PI translator > --------------------------------------------------- > > Key: TEIID-4209 > URL: https://issues.jboss.org/browse/TEIID-4209 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > As reported with https://developer.jboss.org/thread/269357 the PI driver does not support getShort for database metadata calls, even if that is expected by the JDBC spec. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2016