July 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1956) WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1

by Pramod Kumar (JIRA)

Pramod Kumar created TEIID-1956: ----------------------------------- Summary: WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1 Key: TEIID-1956 URL: https://issues.jboss.org/browse/TEIID-1956 Project: Teiid Issue Type: Bug Affects Versions: 7.6 Environment: Operating system: Windows 7 Eclipse Version: Helios Service Release 1 Reporter: Pramod Kumar Assignee: Steven Hawkins I am trying to execute a query similar to the following query: select count(*) from SCHEMA1.STUDENTVIEW as STD_VIEW left join SCHEMA1.LIBRARY LIB on STD_VIEW.sid = LIB.sid where LIB.sid = STD_VIEW.sid and LIB.semister = '4'; The above query works fine in DB2. But throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1 when trying to execute in Teiid Designer version 7.6. -- 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, 5 months

5
29
0 / 0

[JBoss JIRA] (TEIID-2108) JDBC socket is not encrypting client messages by default

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2108: ------------------------------------- Summary: JDBC socket is not encrypting client messages by default Key: TEIID-2108 URL: https://issues.jboss.org/browse/TEIID-2108 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 8.1 The default configuration for the server should encrypt client login traffic. However the SSLConfiguration class is checking for a value of logIn, not login as specified in the 8.x and 7.x configs. -- 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, 5 months

3
18
0 / 0

[JBoss JIRA] (TEIID-2120) BatchIterator can prematurely terminate

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2120: ------------------------------------- Summary: BatchIterator can prematurely terminate Key: TEIID-2120 URL: https://issues.jboss.org/browse/TEIID-2120 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical If a save on mark batchiterator reads through a batch in a mark state it will not be saved to the buffer and then not be available for re-reading. This specifically affects the right side of already sorted non-full outer merge joins with match regions that are sufficiently large to span batches. -- 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, 5 months

2
17
0 / 0

[JBoss JIRA] (TEIID-1925) In RHQ Plugin the View VDB Requests action fails with NoSuchMethod org.teiid.rhq.plugin.objects.RequestMetadata.getRequestId()

by Ted Jones (JIRA)

Ted Jones created TEIID-1925: -------------------------------- Summary: In RHQ Plugin the View VDB Requests action fails with NoSuchMethod org.teiid.rhq.plugin.objects.RequestMetadata.getRequestId() Key: TEIID-1925 URL: https://issues.jboss.org/browse/TEIID-1925 Project: Teiid Issue Type: Bug Components: Jopr Plugin Affects Versions: 7.4.1 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.7, 7.4.1 Need to change the rhq-plugin.xml to call getExecutionId() instead of getRequestId() -- 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, 5 months

4
11
0 / 0

[JBoss JIRA] Created: (TEIID-1517) Use tree logic for dependent joins, subquery set, and partitioned joins

by Steven Hawkins (JIRA)

Use tree logic for dependent joins, subquery set, and partitioned joins ----------------------------------------------------------------------- Key: TEIID-1517 URL: https://issues.jboss.org/browse/TEIID-1517 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 The tree logic would help each of the given areas of functionality. Currently subqueryin produces a linear search, partitioning is limited by the bucketing logic, and dependent joins will only create a tree of a limited size. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 5 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1636) Programmatically configure internal materialized views

by Mark Addleman (JIRA)

Programmatically configure internal materialized views ------------------------------------------------------ Key: TEIID-1636 URL: https://issues.jboss.org/browse/TEIID-1636 Project: Teiid Issue Type: Bug Affects Versions: 7.3 Reporter: Mark Addleman Assignee: Steven Hawkins I am trying to programatically create a materialized view from the MetadataFactory object. I have created a table object using addTable() and then I call setMaterialized(true). I see there are a couple of other related method names in Table (setMaterializedStagedTable and setMaterializedTable). I assume those are when materializing to an external database. What I am doing is incorrect, however. When I try to issue a refresh CALL SYSADMIN.refreshMatView(viewname=>'xyz_metadata.property', invalidate=>false), I get the following exception: QueryMetadataException]QueryPlan could not be found for physical group chorus_metadata.property at org.teiid.query.metadata.TransformationMetadata.getVirtualPlan(TransformationMetadata.java:453) at org.teiid.query.metadata.TempMetadataAdapter.getVirtualPlan(TempMetadataAdapter.java:253) at org.teiid.query.optimizer.relational.RelationalPlanner.getGlobalTempTableMetadataId(RelationalPlanner.java:1136) at org.teiid.query.tempdata.TempTableDataManager.handleSystemProcedures(TempTableDataManager.java:320) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188) 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.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.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) 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) 13 Jun 2011 17:05:43,663 PDT INFO [MATVIEWS] Loading materialized view table #MAT_XYZ_METADATA.PROPERTY Subsequent calls to the refresh stored procedure yield an NPE else in Teiid code. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 5 months

3
14
0 / 0

[JBoss JIRA] (TEIID-2107) Key usage can convert an outer join into an inner join

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2107: ------------------------------------- Summary: Key usage can convert an outer join into an inner join Key: TEIID-2107 URL: https://issues.jboss.org/browse/TEIID-2107 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.1 If a left outer join is against a table/view with a index and the join is using all equi-join predicates and there is an additional predicate beyond what is in the index, then the join will be erroneously converted to an inner join. -- 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, 5 months

2
12
0 / 0

[JBoss JIRA] (TEIID-2086) Local result set cache is not transactionally consistent

by Steven Hawkins (JIRA)

11 years, 5 months

2
11
0 / 0

[JBoss JIRA] (TEIID-2087) Order by clause causes org.teiid.core.TeiidException

by Johnathon Lee (JIRA)

11 years, 5 months

3
26
0 / 0

[JBoss JIRA] (TEIID-2111) Teiid Stored Procedure should support variable length arguments

by Rajasekhar Kota (JIRA)

Rajasekhar Kota created TEIID-2111: -------------------------------------- Summary: Teiid Stored Procedure should support variable length arguments Key: TEIID-2111 URL: https://issues.jboss.org/browse/TEIID-2111 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.0, 7.7 Environment: Windows 7, Jboss 5.x + Teiid7.x Reporter: Rajasekhar Kota Assignee: Steven Hawkins We need extended support of Stored procedures with providing support of variable length arguments(vararg). It saves our efforts a lot in our current product. -- 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, 5 months

2
7
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2012