September 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5066) Move resource-adapters configuration style more adaptable to Spring/OpenShift based datasources

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-5066: ----------------------------------- Summary: Move resource-adapters configuration style more adaptable to Spring/OpenShift based datasources Key: TEIID-5066 URL: https://issues.jboss.org/browse/TEIID-5066 Project: Teiid Issue Type: Enhancement Components: Connector API Reporter: Ramesh Reddy Assignee: Ramesh Reddy The current configuration in the resource-adapters, i.e. ManagedConnectionFactory and managed connection are so tightly integrated with JCA semantics that use of this connection code else where in environments like Spring Boot or Embedded or OpenShift makes it either cumbersome or impossible. All resource-adapter modules need to be refactored such that JCA semantics are add-ons rather than main part of it. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5065) Unable to connect to VDB having names with unicode characters

by Pranav K (JIRA)

Pranav K created TEIID-5065: ------------------------------- Summary: Unable to connect to VDB having names with unicode characters Key: TEIID-5065 URL: https://issues.jboss.org/browse/TEIID-5065 Project: Teiid Issue Type: Bug Components: JDBC Driver Reporter: Pranav K Assignee: Steven Hawkins Priority: Minor Fix For: 10.0 Unable to connect to VDB having names with unicode characters or most characters of any other language -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5063) Issues with bigdecimal values and odata

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5063: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1491378, https://bugzilla.redhat.com/show_bug.cgi?id=1451785 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1491378) > Issues with bigdecimal values and odata > --------------------------------------- > > Key: TEIID-5063 > URL: https://issues.jboss.org/browse/TEIID-5063 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 9.1, 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 10.0, 8.12.x-6.4, 9.2.6, 9.3.4 > > > Usage of bigdecimal literals in odata4 translator literals or procedure parameters results in an exception about the facet not being satisfied. > We are also with TEIID-4269 we were allowing more than just trailing 0s to be trimmed from the numeric values. This results in situations where you could return an entity with a value, but could not look it up by that value (as it would no longer be equal). We should instead let the facet fail if we can't just trim zeros. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4565) Add objects table to system schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4565?page=com.atlassian.jira.plugin... ] Work on TEIID-4565 started by Steven Hawkins. --------------------------------------------- > Add objects table to system schema > ---------------------------------- > > Key: TEIID-4565 > URL: https://issues.jboss.org/browse/TEIID-4565 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Johnston > Assignee: Steven Hawkins > Fix For: 10.0 > > > The addition of a objects table would make it simpler to join to when extensions are implemented. > An example might be something similar to this query: > select sysObjects.* > from ( > select t.schemaName as Parent,t.name, t.uid ,'Table' as ObjectType > from sys.tables t > where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true) > UNION > select c.tableName as Parent,c.name, c.uid,'Column' as ObjectType > from sys.columns c > where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true) > UNION > select null as Parent,e.Value as Name,e.uid,'Property' as ObjectType > from sys.properties as e) as SysObjects -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 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... ] Work on TEIID-4208 started by Steven Hawkins. --------------------------------------------- > Increase plan parallelism > ------------------------- > > Key: TEIID-4208 > URL: https://issues.jboss.org/browse/TEIID-4208 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > 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 (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5020) Join query results in NullPointerException

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5020?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5020: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1491752, https://bugzilla.redhat.com/show_bug.cgi?id=1480713 Bugzilla Update: Perform > Join query results in NullPointerException > ------------------------------------------ > > Key: TEIID-5020 > URL: https://issues.jboss.org/browse/TEIID-5020 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.11.6_3, 9.3.2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 10.0, 8.12.x-6.4, 9.3.3, 8.12.13.6_3 > > > Running Join query results in NPE: > 10:36:06,836 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue17) TEIID30019 Unexpected exception for request KuTljjNz7YSM.1: java.lang.NullPointerException > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:423) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:415) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:491) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:399) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:276) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:223) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:243) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:186) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.<init>(ConnectorWorkItem.java:176) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.datamgr.ConnectorManager.registerRequest(ConnectorManager.java:203) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:997) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:179) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:497) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.AccessNode.openInternal(AccessNode.java:265) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:168) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:123) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:105) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:231) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131] > at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2834) Use FunctionMethod metadata internally for built-in aggregates

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2834?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-2834: ------------------------------------- Fix Version/s: 10/x (was: 10.0) Priority: Minor (was: Major) Assignee: (was: Steven Hawkins) > Use FunctionMethod metadata internally for built-in aggregates > -------------------------------------------------------------- > > Key: TEIID-2834 > URL: https://issues.jboss.org/browse/TEIID-2834 > Project: Teiid > Issue Type: Task > Components: Query Engine > Reporter: Steven Hawkins > Priority: Minor > Fix For: 10/x > > > With TEIID-2815 we added aggregate function definitions for consumption by designer, but it would be good to have them consistently handled internally. The metadata needs to accommodate count\(*) and textagg. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5050) CLOB instead of STRING

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5050?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5050. ----------------------------------- Resolution: Done Added a new JDBC import property importer.importLargeAsLob to import values as clob/blob rather than string/varbinary. > CLOB instead of STRING > ---------------------- > > Key: TEIID-5050 > URL: https://issues.jboss.org/browse/TEIID-5050 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Lukáš Svačina > Assignee: Steven Hawkins > Fix For: 10.0 > > > Postgresql translator should replace source's datatype `text` for `clob` instead of `string(4000)` by default. > In general teiid should be able to handle any input source without data corruption. So if source's column datatype doesn't fit into string(4000), it should use some kind of unlimited datatype e.g. `clob`. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-147) Support for JAVA Stored Procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-147?page=com.atlassian.jira.plugin.... ] Steven Hawkins updated TEIID-147: --------------------------------- Fix Version/s: 10.x (was: 10.0) > Support for JAVA Stored Procedures > ---------------------------------- > > Key: TEIID-147 > URL: https://issues.jboss.org/browse/TEIID-147 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 9.x > Reporter: Ramesh Reddy > Fix For: 10.x > > > Currently the Stored procedure support is lacking for both our procedure language and XQuery. Procedure support could be extended to java (or groovy) code, which will provide a powerful engine to execute a arbitrary queries. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4941) [RFE] Display a more informative error message when a query takes too long and times out

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4941?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4941. ----------------------------------- Resolution: Done updated the request work item to add the cancel reason to the cancel exception sent to the client. > [RFE] Display a more informative error message when a query takes too long and times out > ---------------------------------------------------------------------------------------- > > Key: TEIID-4941 > URL: https://issues.jboss.org/browse/TEIID-4941 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.8 > Reporter: Yuming Zhu > Assignee: Steven Hawkins > Priority: Minor > Fix For: 10.0 > > > This issue is from our user of RedHat internal pnt-devops Teiid. > Reality > {code:java}$ echo "SOME COMPLICATED QUERY" | psql -h virtualdb.engineering.redhat.com -p 5433 -d public > ERROR: 57014 TEIID30160 The request AXhWh34gdzbY.0 has been cancelled. > DETAIL: org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request AXhWh34gdzbY.0 has been cancelled. > {code} > Expected > {code:java}$ echo "SOME COMPLICATED QUERY" | psql -h virtualdb.engineering.redhat.com -p 5433 -d public > The request AXhWh34gdzbY.0 has been cancelled. The query takes too long/timed out/whatever/resources exhausted > {code} > -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2017