August 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-942) Make ad hoc temp tables transactional

by Steven Hawkins (JIRA)

Make ad hoc temp tables transactional ------------------------------------- Key: TEIID-942 URL: https://jira.jboss.org/jira/browse/TEIID-942 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 Ad hoc temp tables are scoped to the session and should be transactional. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1737) Error: Temporary table does not exist when using WITH clause and SQL Server

by Mark Brocato (JIRA)

Error: Temporary table does not exist when using WITH clause and SQL Server --------------------------------------------------------------------------- Key: TEIID-1737 URL: https://issues.jboss.org/browse/TEIID-1737 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5 Environment: JBoss AS 5.1, TEIID 7.5, SQL Server 2008 Reporter: Mark Brocato Assignee: Steven Hawkins It appears that the WITH clause is not compatible with SQL Server. The following simple query errors out: with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 The error message is: Remote org.teiid.api.exception.query.QueryProcessingException: Temporary table "T1" does not exist. With Log4J debugging turned on I was able to do a little digging and it looks like to me that TEIID is sending the correct SQL down into SQL Server, but then gets confused when processing the result. Here is the relevant portion of the log: 12:56:29,910 DEBUG [COMMAND_LOG] START USER COMMAND: startTime=2011-08-31 12:56:29.91 requestID=QsxTHCTkSXXC.0 txID=null sessionID=QsxTHCTkSXXC applicationName=JDBC principal=user@teiid-security vdbName=Qiagram vdbVersion=1 sql=with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 12:56:29,912 DEBUG [PROCESSOR] Request Thread QsxTHCTkSXXC.0 with state NEW 12:56:29,913 DEBUG [PROCESSOR] QsxTHCTkSXXC.0 No cache directive 12:56:29,913 DEBUG [PROCESSOR] QsxTHCTkSXXC.0 executing with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 12:56:29,916 DEBUG [PROCESSOR] ProcessTree for QsxTHCTkSXXC.0 AccessNode(1) output=[id] WITH T1 (T1.id) AS (SELECT g_0.id FROM SCRAP.DEMO.dbo.ACCESS_GROUP AS g_0) SELECT g_0.id AS c_0 FROM T1 AS g_0 12:56:29,917 DEBUG [TXN_LOG] before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@1a53c407(QsxTHCTkSXXC) 12:56:29,917 DEBUG [TXN_LOG] after getOrCreateTransactionContext : QsxTHCTkSXXC NONE ID:NONE 12:56:29,917 DEBUG [BUFFER_MGR] Creating FileStore: 53 12:56:29,917 DEBUG [BUFFER_MGR] Creating TupleBuffer: 53 [id] [integer] of type PROCESSOR 12:56:29,918 DEBUG [PROCESSOR] QueryProcessor: closing processor 12:56:29,918 DEBUG [PROCESSOR] Request Thread QsxTHCTkSXXC.0 - error occurred [QueryProcessingException]Temporary table "T1" does not exist. at org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:487) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:176) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:358) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:153) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:352) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:207) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:194) 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) 12:56:29,923 DEBUG [COMMAND_LOG] ERROR USER COMMAND: endTime=2011-08-31 12:56:29.923 requestID=QsxTHCTkSXXC.0 txID=null sessionID=QsxTHCTkSXXC principal=user@teiid-security vdbName=Qiagram vdbVersion=1 finalRowCount=null 12:56:29,924 WARN [PROCESSOR] Processing exception 'Temporary table "T1" does not exist.' for request QsxTHCTkSXXC.0. Exception type org.teiid.api.exception.query.QueryProcessingException thrown from org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240). Enable more detailed logging to see the entire stacktrace. 12:56:29,924 DEBUG [PROCESSOR] Removing tuplesource for the request QsxTHCTkSXXC.0 12:56:29,924 DEBUG [BUFFER_MGR] Removing TupleBuffer: 53 12:56:29,924 DEBUG [PROCESSOR] Sending error to client QsxTHCTkSXXC.0 [QueryProcessingException]Temporary table "T1" does not exist. at org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:487) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:176) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:358) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:153) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:352) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:207) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:194) 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) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1736) Window function capabilities incorrect

by Steven Hawkins (JIRA)

Window function capabilities incorrect -------------------------------------- Key: TEIID-1736 URL: https://issues.jboss.org/browse/TEIID-1736 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6 The CapabilitiesConverter is using the advanced olap instead of the elementary olap supports property to determine if window functions can be pushed down. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1594) Add to the sandox the example Coherence translator and connector

by Van Halbert (JIRA)

Add to the sandox the example Coherence translator and connector ---------------------------------------------------------------- Key: TEIID-1594 URL: https://issues.jboss.org/browse/TEIID-1594 Project: Teiid Issue Type: Task Components: Misc. Connectors Affects Versions: 8.0 Reporter: Van Halbert Assignee: Van Halbert Priority: Minor Adding to the sandbox example connector and translator for access an Oracle Coherence Cache. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1693) Update Teiid ADmin Console Documentation

by Ted Jones (JIRA)

Update Teiid ADmin Console Documentation ---------------------------------------- Key: TEIID-1693 URL: https://issues.jboss.org/browse/TEIID-1693 Project: Teiid Issue Type: Task Components: Documentation Affects Versions: 7.4 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.4.1 The documentation needs to be brought up to date -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

2
3
0 / 0

[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, 8 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, 8 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, 8 months

3
3
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, 8 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1560) Add support for user defined / pushdown aggregate functions

by Steven Hawkins (JIRA)

Add support for user defined / pushdown aggregate functions ----------------------------------------------------------- Key: TEIID-1560 URL: https://issues.jboss.org/browse/TEIID-1560 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 Add support for user defined aggregate functions. This would also affect the function model metadata. Our aggregate handling logic will need to be generalized to make this possible. Starting with the parser we've got special handling for built-in aggregates. for user defined aggregate handling just a static method will not work as the function needs to retain state across each group. Could require that the implementing class extends AggregateFunction. Could also allow user defined aggregates to take an order by clause. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 8 months

2
4
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2011