June 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2323) Non-pushdown update set clause values are not properly compensated for

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2323?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2323. --------------------------------- > Non-pushdown update set clause values are not properly compensated for > ---------------------------------------------------------------------- > > Key: TEIID-2323 > URL: https://issues.jboss.org/browse/TEIID-2323 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > When a physical update has a non-pushdown value in the set clause, it will fail to plan even if compensation is possible. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2504) Improve socket results processing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2504?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2504. --------------------------------- > Improve socket results processing > --------------------------------- > > Key: TEIID-2504 > URL: https://issues.jboss.org/browse/TEIID-2504 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver, Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4, 7.7.7 > > > To increase large result transfer performance we can: > 1. use a prefetch (which ideally will be performed before full deserialization) > 2. allow for the client to fetch multiple server batches (although this has quite a few implementation considerations -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2491) ODBC ScriptReader workarounds do not handle EOF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2491?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2491. --------------------------------- > ODBC ScriptReader workarounds do not handle EOF > ----------------------------------------------- > > Key: TEIID-2491 > URL: https://issues.jboss.org/browse/TEIID-2491 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4, 7.7.7 > > > Issuing a query such as select 'foo'::bar > will result in an error since the workaround to drop the ::bar appends the EOF to the sql text. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2534) Object protocol errors provide no client information

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2534?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2534. --------------------------------- > Object protocol errors provide no client information > ---------------------------------------------------- > > Key: TEIID-2534 > URL: https://issues.jboss.org/browse/TEIID-2534 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Driver, Server > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Labels: 8.4.Final > Fix For: 8.4 > > > Issues when writing an object value to output result in a terminated connection and no meaningful client exception. It would be better to have a meaningful exception and to not terminate the connection - as it actually hasn't been corrupted. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2533) ConcurrentModificationException when list-sessions operation is issued

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2533?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2533. --------------------------------- > ConcurrentModificationException when list-sessions operation is issued > ---------------------------------------------------------------------- > > Key: TEIID-2533 > URL: https://issues.jboss.org/browse/TEIID-2533 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.0 > Environment: Teiid 8.4.CR2 and EAP 6.1 Alpha > Reporter: Van Halbert > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.4 > > > Saw the following exception in the server log, but not sure what I did to trigger it (unable to reproduce): > 07:31:32,834 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 1) JBAS014612: Operation ("list-sessions") failed - address: ([("subsystem" => "teiid")]): java.util.ConcurrentModificationException > at java.util.ArrayList$Itr.checkForComodification(ArrayList.java:819) [rt.jar:1.7.0_13] > at java.util.ArrayList$Itr.next(ArrayList.java:791) [rt.jar:1.7.0_13] > at org.teiid.jboss.ListSessions.executeOperation(TeiidOperationHandler.java:245) > at org.teiid.jboss.ListSessions.executeOperation(TeiidOperationHandler.java:225) > at org.teiid.jboss.BaseOperationHandler$1.execute(BaseOperationHandler.java:72) > at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:440) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:322) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.AbstractOperationContext.completeStepInternal(AbstractOperationContext.java:229) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:224) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:142) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:112) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler.doExecute(ModelControllerClientOperationHandler.java:139) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.controller.remote.ModelControllerClientOperationHandler$ExecuteRequestHandler$1.execute(ModelControllerClientOperationHandler.java:108) [jboss-as-controller-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.protocol.mgmt.AbstractMessageHandler$2$1.doExecute(AbstractMessageHandler.java:296) [jboss-as-protocol-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at org.jboss.as.protocol.mgmt.AbstractMessageHandler$AsyncTaskRunner.run(AbstractMessageHandler.java:518) [jboss-as-protocol-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_13] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_13] > at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_13] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2333) PG/H2 default escape handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2333?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2333. --------------------------------- > PG/H2 default escape handling > ----------------------------- > > Key: TEIID-2333 > URL: https://issues.jboss.org/browse/TEIID-2333 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > Both H2 and pg use \ as the default escape character, but Teiid (inline with the spec) assumes no such default. So the pushdown of LIKE without an escape may be incorrect if the pattern contains \. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2342) NullPointerException in TempMetadataID

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2342?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2342. --------------------------------- > NullPointerException in TempMetadataID > -------------------------------------- > > Key: TEIID-2342 > URL: https://issues.jboss.org/browse/TEIID-2342 > Project: Teiid > Issue Type: Bug > Affects Versions: 7.4 > Reporter: RAKESH BALGURI > Assignee: Steven Hawkins > Fix For: 8.3 > > > NullPointerException in TempMetadataID > java.lang.NullPointerException > at java.util.LinkedHashMap.get(LinkedHashMap.java:337) > at org.teiid.query.metadata.TempMetadataID.getProperty(TempMetadataID.java:304) > at org.teiid.query.metadata.TempMetadataAdapter.getFromMetadataCache(TempMetadataAdapter.java:690) > at org.teiid.query.resolver.util.ResolverUtil.getGroupInfo(ResolverUtil.java:468) > at org.teiid.query.resolver.util.ResolverUtil.resolveElementsInGroup(ResolverUtil.java:461) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.getOutputCols(NewCalculateCostUtil.java:567) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.createColStats(NewCalculateCostUtil.java:515) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.estimateSourceNodeCost(NewCalculateCostUtil.java:503) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeNodeCost(NewCalculateCostUtil.java:153) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:135) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:132) > at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeCostForTree(NewCalculateCostUtil.java:121) > at org.teiid.query.optimizer.relational.rules.JoinRegion.initializeCostingInformation(JoinRegion.java:399) > at org.teiid.query.optimizer.relational.rules.RulePlanJoins.execute(RulePlanJoins.java:161) > at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:457) > at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:199) > at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:434) > at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:157) > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:454) > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2339) More optimistic dependent join planning should be implemented when TEMP tables are used for data inputs in WHERE IN clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2339?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2339. --------------------------------- > More optimistic dependent join planning should be implemented when TEMP tables are used for data inputs in WHERE IN clause > -------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-2339 > URL: https://issues.jboss.org/browse/TEIID-2339 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 7.7 > Environment: Windows Server 2008 > Reporter: Tanmoy Palit > Priority: Minor > Fix For: 8.3 > > > Please follow: > https://community.jboss.org/thread/217306 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2340) Teiid script does not correctly cache method references

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2340?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2340. --------------------------------- > Teiid script does not correctly cache method references > ------------------------------------------------------- > > Key: TEIID-2340 > URL: https://issues.jboss.org/browse/TEIID-2340 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > The script engine logic indirectly holds hard references to Method objects, which in turn keeps their classloader alive. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2497) Add support for DECODE(column, column_value, column_to_replace_with)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2497?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2497. --------------------------------- > Add support for DECODE(column, column_value, column_to_replace_with) > -------------------------------------------------------------------- > > Key: TEIID-2497 > URL: https://issues.jboss.org/browse/TEIID-2497 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.6 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Looking at pivot and trying to use it like: > Select salesperson, SUM(DECODE(product, 'CarA', amount)) as ProductCarA, > SUM(DECODE(product, 'CarB', amount)) as ProductCarB, > SUM(DECODE(product, 'CarC', amount)) as ProductCarC > From SALES > Group By salesperson > Teiid's Decode requires you to know the value to substitute, with this option, it can be dynamically substituted at run time. > > See: http://www.clearpeaks.com/blog/data-warehousing/pivot-data-in-sql -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 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 June 2013