May 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1503) Exception during Optimization

by Ramesh Reddy (JIRA)

Exception during Optimization ------------------------------ Key: TEIID-1503 URL: https://issues.jboss.org/browse/TEIID-1503 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 7.4 while running the BQT Query SELECT intkey FROM BQT1.SmallA AS A WHERE convert(shortvalue, integer) = (SELECT MAX(convert(shortvalue, integer)) FROM BQT1.SmallA AS B WHERE b.intnum = a.intnum) ORDER BY intkey I encountered java.lang.ArrayIndexOutOfBoundsException: -1 at java.util.ArrayList.get(ArrayList.java:324) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.filterVirtualElements(RuleAssignOutputElements.java:358) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:168) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:217) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:217) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:163) at org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.execute(RuleAssignOutputElements.java:96) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:462) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:227) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:169) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.planSemiJoin(RuleMergeCriteria.java:283) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:170) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:189) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:189) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.findCriteriaChains(RuleMergeCriteria.java:189) at org.teiid.query.optimizer.relational.rules.RuleMergeCriteria.execute(RuleMergeCriteria.java:146) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:462) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:227) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:169) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:376) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:175) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
9
0 / 0

[JBoss JIRA] Created: (TEIID-1509) Change the default for value caching

by Steven Hawkins (JIRA)

Change the default for value caching ------------------------------------ Key: TEIID-1509 URL: https://issues.jboss.org/browse/TEIID-1509 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 There is a larger performance impact from having value caching enabled with large data sets (which is the more typical deployment scenario) than having value caching disabled and a larger memory footprint. So the value caching default should change to false. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
3
0 / 0

[JBoss JIRA] Closed: (TEIID-1469) EDS Teiid Plugin uses Invalid Datatype Mask for SessionID Parameter to Terminate Session Operation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1469?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1469. --------------------------------- > EDS Teiid Plugin uses Invalid Datatype Mask for SessionID Parameter to Terminate Session Operation > -------------------------------------------------------------------------------------------------- > > Key: TEIID-1469 > URL: https://issues.jboss.org/browse/TEIID-1469 > Project: Teiid > Issue Type: Bug > Components: Jopr Plugin > Affects Versions: 7.3 > Reporter: Ted Jones > Assignee: Van Halbert > Fix For: 7.4 > > > The Terminate Session operation validates the session id parameter as an integer when it is actually alpha-numeric, making it impossible to execute the operation. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-978) Ability to define the 'allowed' values for a type via a defined query. (also relevant to descriptions as well)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-978?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-978. -------------------------------- > Ability to define the 'allowed' values for a type via a defined query. (also relevant to descriptions as well) > -------------------------------------------------------------------------------------------------------------- > > Key: TEIID-978 > URL: https://issues.jboss.org/browse/TEIID-978 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Marc Shirley > -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1481) client url cleanups

by Steven Hawkins (JIRA)

client url cleanups ------------------- Key: TEIID-1481 URL: https://issues.jboss.org/browse/TEIID-1481 Project: Teiid Issue Type: Task Components: JDBC Driver Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 Designer is now leveraging the TeiidURL class for validation of server urls. The messages need internationalized and it would be better to through a checked exception (such as MalformedUrlException) rather than IllegalArgumentException. In addition there is a lot of redundancy with url handling in the Socket/EmbeddedProfile, JDBCURL, and TeiidDataSource. This should be consolidated as much as possible. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1510) RulePushAggregates should consider cost in addition to key information

by Steven Hawkins (JIRA)

RulePushAggregates should consider cost in addition to key information ---------------------------------------------------------------------- Key: TEIID-1510 URL: https://issues.jboss.org/browse/TEIID-1510 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 RulePushAggregates currently only considers whether a key is in use in the grouping columns to not stage an aggregate. It should additionally use a cost check to see if the staged aggregate is cost effective. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
2
0 / 0

[JBoss JIRA] Closed: (TEIID-1093) Request addition of ODC file connections

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1093?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1093. --------------------------------- > Request addition of ODC file connections > ---------------------------------------- > > Key: TEIID-1093 > URL: https://issues.jboss.org/browse/TEIID-1093 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Debbie Steigner > > Customer is requesting to include a standard connection to work with MicroSoft "Office Data Connection"(ODC)files -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-231) Ability to support Connector Level UDF functions in the System

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-231?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-231. -------------------------------- > Ability to support Connector Level UDF functions in the System > -------------------------------------------------------------- > > Key: TEIID-231 > URL: https://issues.jboss.org/browse/TEIID-231 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Affects Versions: 6.0.0 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 7.3, 7.4 > > > Currently we have UDF and Connector capabilities to define some custom functions in supported by a connector, however this is not seem less to deploy along with the connector, as connector functions do not support any parameters or design tools to define/declare them in CDK. We need a way to define and develop functions supported by a connector. > Suggestions. > 1) Use designer to define capabilities in a XMI file and attach with the connector, and let the server or MMQuery load these XMI files dynamically into the engine. > 2) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1416) Admin console shows no information about sessions

by Boris Belovic (JIRA)

Admin console shows no information about sessions ------------------------------------------------- Key: TEIID-1416 URL: https://issues.jboss.org/browse/TEIID-1416 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 7.1 Reporter: Boris Belovic Assignee: Steven Hawkins Admin console shows no session information. The results table is empty even if the session is active (= connections to VDB weren't closed). -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1479) Teiid Documentation does not include MS SQL Server as an available translator in section 10.2.2. JDBC Translator of the Reference Guide

by Van Halbert (JIRA)

Teiid Documentation does not include MS SQL Server as an available translator in section 10.2.2. JDBC Translator of the Reference Guide --------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1479 URL: https://issues.jboss.org/browse/TEIID-1479 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 7.4 Reporter: Van Halbert Assignee: Steven Hawkins Teiid Documentation does not include MS SQL Server as an available translator in section "10.2.2. JDBC Translato" of the Reference Guide. I checked versions 7.3 and 7.1. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
2
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2011