May 2012 - teiid-issues - Jboss List Archives

[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

13 years, 7 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

13 years, 7 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

13 years, 7 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

13 years, 7 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

13 years, 7 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

13 years, 7 months

8
11
0 / 0

[JBoss JIRA] (TEIID-2060) Correct exception toString methods

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2060: ------------------------------------- Summary: Correct exception toString methods Key: TEIID-2060 URL: https://issues.jboss.org/browse/TEIID-2060 Project: Teiid Issue Type: Quality Risk Components: Common Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.7.1 With TEIID-2022 it was noticed that exception toString methods were causing either meaningless or excessive listings in stack traces. -- 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

13 years, 7 months

1
3
0 / 0

[JBoss JIRA] (TEIID-2045) SQL Error occurs trying to load External Materialized table when the 2 source models are using the same -ds.xml

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-2045: -------------------------------------- Summary: SQL Error occurs trying to load External Materialized table when the 2 source models are using the same -ds.xml Key: TEIID-2045 URL: https://issues.jboss.org/browse/TEIID-2045 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Debbie Steigner Assignee: Steven Hawkins Attachments: Parts3.vdb A Customer was testing external materialization in Teiid/EDS, he created physical model mv_views based on External_CacheViews.supplierinfo (Parts3.vdb attached, uses the partssupplier db). Supplierinfo is a join between parts SourceB and SourceA, well if you assign the same Datasource (using the same ds.xml file) it errors trying to load the table. INSERT INTO mv_views.supplierinfo SELECT * FROM External_CacheViews.supplierinfo OPTION NOCACHE Error: org.teiid.query.sql.symbol.AllSymbol cannot be cast to org.teiid.query.sql.symbol.SingleElementSymbol SQLState: 38000 ErrorCode: 0 -- 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

13 years, 7 months

3
11
0 / 0

[JBoss JIRA] (TEIID-2005) Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-2005: -------------------------------------- Summary: Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors Key: TEIID-2005 URL: https://issues.jboss.org/browse/TEIID-2005 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Debbie Steigner Assignee: Steven Hawkins Per Documentation, setup an oracle sequence or use the EV.vdb on slnttech04.mmx.gss.redhat.com:31100 run the below query: select cpe_seq from Evolvecontrol.seq_gen It will error with [SELECT g_0.tid_cl_seq.nextval FROM dual g_0] [SQLException]ORA-02289: sequence does not exist -- 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

13 years, 7 months

3
19
0 / 0

[JBoss JIRA] (TEIID-2057) Problem with dynamic VDB re-deploy when it contains a Virtual Model

by Mark Drilling (JIRA)

Mark Drilling created TEIID-2057: ------------------------------------ Summary: Problem with dynamic VDB re-deploy when it contains a Virtual Model Key: TEIID-2057 URL: https://issues.jboss.org/browse/TEIID-2057 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 8.0 Reporter: Mark Drilling Assignee: Ramesh Reddy I am using the AdminAPI to add a View Model to a dynamic VDB. The initial deployment succeeds - the VDB deploys and i can query the View. However, then I retrieve the VDB via the Admin API. In debug, I can see on the view model - that the schemaText field is now null. If I attempt to make other changes and re-deploy, the re-deploy fails - the parser chokes on the null schemaText -- 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

13 years, 7 months

3
22
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2012