February 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1701) Misc procedure enhancements

by Steven Hawkins (JIRA)

Misc procedure enhancements --------------------------- Key: TEIID-1701 URL: https://issues.jboss.org/browse/TEIID-1701 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Add support for compound/block statements (rather than only allowing them at the top level of loops/if), BEGIN [[NOT] ATOMIC] for block level transactions, loop/block labels, and the leave statement. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1602) Add support for like_regex and other regex functions

by Steven Hawkins (JIRA)

Add support for like_regex and other regex functions ---------------------------------------------------- Key: TEIID-1602 URL: https://issues.jboss.org/browse/TEIID-1602 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.5 Consider adding: like_regex substring_regex (as well as ANSI substring handling) position_regex this would somewhat obviate the need to add similar predicate handling although that should be added eventually as well. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1671) Need to add a place holder for the future deployment of Netezza

by Van Halbert (JIRA)

Need to add a place holder for the future deployment of Netezza --------------------------------------------------------------- Key: TEIID-1671 URL: https://issues.jboss.org/browse/TEIID-1671 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Ramesh Reddy Priority: Blocker Fix For: 7.4.1 Add a place holder in 7.4.x for the ability to slide in Netezza when it becomes available. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
3
0 / 0

[JBoss JIRA] (TEIID-1843) StackOverflow using a changing expression as a boolean condition

by Steven Hawkins (Created) (JIRA)

StackOverflow using a changing expression as a boolean condition ---------------------------------------------------------------- Key: TEIID-1843 URL: https://issues.jboss.org/browse/TEIID-1843 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6 If a changing value is used as a condition directly, e.g. col = case when changing.y then ... The rewriter will fail to replace the changing value and we will continually attempt to rewrite the base update as a loop procedure. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
2
0 / 0

[JBoss JIRA] (TEIID-1771) 7.3 or older clients see the wrong column metadata

by Steven Hawkins (Created) (JIRA)

7.3 or older clients see the wrong column metadata -------------------------------------------------- Key: TEIID-1771 URL: https://issues.jboss.org/browse/TEIID-1771 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 The fix for TEIID-1534 corrected column name vs. column label. However 7.3 clients use the column name and label interchangeably and typically uses column name. When running against 7.4 or later the column name needs to be reported as the label for legacy clients to work appropriately. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-1694) Add addition ansi sql function support

by Steven Hawkins (JIRA)

Add addition ansi sql function support -------------------------------------- Key: TEIID-1694 URL: https://issues.jboss.org/browse/TEIID-1694 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.5 Add parsing/support for: substring using from/for trim extract -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
3
0 / 0

[JBoss JIRA] (TEIID-1836) NPE running query of Web service (WSDL imported into Relational Model)

by Paul Nittel (Created) (JIRA)

NPE running query of Web service (WSDL imported into Relational Model) ---------------------------------------------------------------------- Key: TEIID-1836 URL: https://issues.jboss.org/browse/TEIID-1836 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: server.log, WsdlToRel_MPS.zip Using the attached project, I executed (from DTP): exec MaybeThisOne.NewProcedure() On the server, I received this exception: 2011-11-18 09:02:53,137 ERROR [org.teiid.CONNECTOR] (Worker18_QueryProcessorQueue105) Connector worker process failed for atomic-request=vMl7hPK9M4Fm.0.10.8 java.lang.NullPointerException at org.apache.cxf.transport.DestinationFactoryManagerImpl.getDestinationFactoryForUri(DestinationFactoryManagerImpl.java:127) at org.apache.cxf.jaxws.ServiceImpl.createEndpointInfo(ServiceImpl.java:510) at org.apache.cxf.jaxws.ServiceImpl.getJaxwsEndpoint(ServiceImpl.java:248) at org.apache.cxf.jaxws.ServiceImpl.createDispatch(ServiceImpl.java:617) at org.apache.cxf.jaxws.ServiceImpl.createDispatch(ServiceImpl.java:598) at javax.xml.ws.Service.createDispatch(Service.java:325) at org.teiid.resource.adapter.ws.WSConnectionImpl.createDispatch(WSConnectionImpl.java:234) at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:99) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:264) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:80) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:121) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:230) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) 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:662) 2011-11-18 09:02:53,138 ERROR [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue106) Unexpected exception for request vMl7hPK9M4Fm.0 java.lang.NullPointerException at org.apache.cxf.transport.DestinationFactoryManagerImpl.getDestinationFactoryForUri(DestinationFactoryManagerImpl.java:127) at org.apache.cxf.jaxws.ServiceImpl.createEndpointInfo(ServiceImpl.java:510) at org.apache.cxf.jaxws.ServiceImpl.getJaxwsEndpoint(ServiceImpl.java:248) at org.apache.cxf.jaxws.ServiceImpl.createDispatch(ServiceImpl.java:617) at org.apache.cxf.jaxws.ServiceImpl.createDispatch(ServiceImpl.java:598) at javax.xml.ws.Service.createDispatch(Service.java:325) at org.teiid.resource.adapter.ws.WSConnectionImpl.createDispatch(WSConnectionImpl.java:234) at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:99) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:264) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:80) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:121) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:230) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) 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:662) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

8
11
0 / 0

[JBoss JIRA] (TEIID-1882) EOFException with 7.6 client against a 7.4 server

by Steven Hawkins (Created) (JIRA)

EOFException with 7.6 client against a 7.4 server ------------------------------------------------- Key: TEIID-1882 URL: https://issues.jboss.org/browse/TEIID-1882 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.6 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6.1 The Handshake and LogonResult classes are not properly accounting for backwards compatibility. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

5
22
0 / 0

[JBoss JIRA] (TEIID-1954) System Schema does not show metadata for Indexes in the SYS.Keys or SYS.KeyColumns table

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-1954: -------------------------------------- Summary: System Schema does not show metadata for Indexes in the SYS.Keys or SYS.KeyColumns table Key: TEIID-1954 URL: https://issues.jboss.org/browse/TEIID-1954 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Debbie Steigner Assignee: Steven Hawkins Attachments: ora.vdb System Schema does not show metadata for Indexes in the SYS.Keys or SYS.KeyColumns tables -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
18
0 / 0

[JBoss JIRA] (TEIID-1868) Internal Materialized View - Load/Refresh and Assertion Failed

by John Tan (Created) (JIRA)

Internal Materialized View - Load/Refresh and Assertion Failed -------------------------------------------------------------- Key: TEIID-1868 URL: https://issues.jboss.org/browse/TEIID-1868 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4, 7.3 Environment: Windows Server 2008 R2 64 bits, JBoss EAP 5.1 Reporter: John Tan Assignee: Steven Hawkins We have about 20 tables in materialized view (internal with cache hint - /*+ cache(ttl:14400000) */). 2 dreaded behaviours: 1. On start up with application (application starts hitting app), certain query will cause ASSERTION FAILED 2. On reloading cache, teiid starts to fails with same behaviour. 2011-12-14 18:26:40,201 WARN [org.teiid.CONNECTOR] (Worker2228_QueryProcessorQueue1132419) Connector worker process failed for atomic-request=mCMnhhZ9fLcU.100.3.334092 [JDBCExecutionException] 0: Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s):[....] 1 [TeiidSQLException]ASSERTION FAILED: expected reference to be not null 2 [TeiidException]ASSERTION FAILED: expected reference to be not null 3 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107) 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:662) Caused by: org.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:497) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:214) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86) ... 12 more Caused by: [TeiidException]ASSERTION FAILED: expected reference to be not null 1 [AssertionError]ASSERTION FAILED: expected reference to be not null at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:177) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:557) at org.teiid.dqp.internal.process.RequestWorkItem.attemptClose(RequestWorkItem.java:335) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:218) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) ... 6 more Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:366) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:141) at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:130) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:410) at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:402) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:437) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:152) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:129) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:445) at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:218) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203) at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214) at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168) at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96) at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) ... 7 more 2011-12-14 18:26:40,201 WARN [org.teiid.PROCESSOR] (Worker2205_QueryProcessorQueue1132421) Processing exception 'Error Code:0 Message:Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s): [....] for request mCMnhhZ9fLcU.100. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.core.util.Assertion.failed(Assertion.java:73). Enable more detailed logging to see the entire stacktrace. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

8
32
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2012