August 2012 - teiid-issues - Jboss List Archives

[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

12 years, 1 month

2
5
0 / 0

[JBoss JIRA] (TEIID-2168) SessionAware cache needs to use Infinispan as Cache Store always

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2168: ----------------------------------- Summary: SessionAware cache needs to use Infinispan as Cache Store always Key: TEIID-2168 URL: https://issues.jboss.org/browse/TEIID-2168 Project: Teiid Issue Type: Enhancement Components: Server Affects Versions: 8.2 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.2 Currently SessionAwareCache uses the Infinispan cache factory for the distributed cache results and uses the Teiid defined DefaultCache for local storage of session scoped results. The usage of DefaultCache should be entirely removed and replaced with Infinispan's non-replicated local cache. This provides more consistent implementation of the cache store with better eviction policies. -- 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

12 years, 1 month

2
2
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

12 years, 1 month

3
14
0 / 0

[JBoss JIRA] (TEIID-2147) FileInputStreamFactory lobs may be inappropriately inlined

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2147: ------------------------------------- Summary: FileInputStreamFactory lobs may be inappropriately inlined Key: TEIID-2147 URL: https://issues.jboss.org/browse/TEIID-2147 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.6 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.1 The check for storage mode does not take into account if the outputstream is backed by the filestore, which means that it will report memory storage even for large lobs. -- 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

12 years, 1 month

2
6
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

12 years, 1 month

2
12
0 / 0

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

by Steven Hawkins (JIRA)

12 years, 1 month

2
11
0 / 0

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

by Johnathon Lee (JIRA)

12 years, 1 month

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

12 years, 1 month

2
7
0 / 0

[JBoss JIRA] (TEIID-2096) Colons need to be escaped

by Simon Green (JIRA)

Simon Green created TEIID-2096: ---------------------------------- Summary: Colons need to be escaped Key: TEIID-2096 URL: https://issues.jboss.org/browse/TEIID-2096 Project: Teiid Issue Type: Bug Environment: Fedora 17, bash, psql from Fedora repo Reporter: Simon Green Assignee: Steven Hawkins $ psql -h vdb.engineering.redhat.com -p 35432 -U sgreen -d EngVDBR Password for user sgreen: psql (9.1.4, server 8.1.4) WARNING: psql version 9.1, server version 8.1. Some psql features might not work. SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Type "help" for help. EngVDBR=> SELECT class, COUNT(*) FROM Bugzilla.audit_log GROUP BY class; class | count ---------------------------------------------------+------- Bugzilla::Component | 3686 Bugzilla::Extension::ExternalBugs::Bug | 3110 Bugzilla::Extension::ExternalBugs::Type | 4 Bugzilla::Extension::ExternalBugs::Type::Bugzilla | 1 Bugzilla::Extension::Releases::Release | 5 Bugzilla::Field | 27 Bugzilla::Field::Choice::cf_extra_component | 421 Bugzilla::Field::Choice::cf_extra_version | 20 Bugzilla::Field::Choice::cf_verified | 1 Bugzilla::FlagType | 89 Bugzilla::Group | 34 Bugzilla::Milestone | 81 Bugzilla::Product | 30 Bugzilla::Release | 66 Bugzilla::User | 3316 Bugzilla::Version | 79 (16 rows) EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla::Component' LIMIT 1; user_id | class | object_id | field | removed | added | at_time ---------+-------+-----------+-------+---------+-------+--------- (0 rows) EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla\:\:Component' LIMIT 1; user_id | class | object_id | field | removed | added | at_time ---------+---------------------+-----------+--------------+---------+--------+-- --------------------- 271726 | Bugzilla::Component | 91289 | initialowner | 173606 | 295575 | 2 012-05-19 19:33:15.0 (1 row) Question is. Why do the colons need to be backspaced to get a result? -- 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

12 years, 1 month

4
9
0 / 0

[JBoss JIRA] (TEIID-2162) VDB attachements may get lost when using vdb imports

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2162: ------------------------------------- Summary: VDB attachements may get lost when using vdb imports Key: TEIID-2162 URL: https://issues.jboss.org/browse/TEIID-2162 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The CompositeVDB logic does not copy all attachments. It looks like the only affect now is that the classloader is not propagated, which may only be an issue for the JPA translator. -- 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

12 years, 1 month

2
3
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2012