August 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1814) Document Use Cases for Teiid Integration with AS 7 Console

by Ted Jones (Created) (JIRA)

Document Use Cases for Teiid Integration with AS 7 Console ---------------------------------------------------------- Key: TEIID-1814 URL: https://issues.jboss.org/browse/TEIID-1814 Project: Teiid Issue Type: Task Components: Documentation Reporter: Ted Jones Assignee: Ted Jones Fix For: 8.0 Need use cases defined along with associated operations in the Teiid subsystem. -- 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, 5 months

3
3
0 / 0

[JBoss JIRA] (TEIID-1991) GROUP BY pushdown into subselect of UNIONs

by Mark Addleman (JIRA)

Mark Addleman created TEIID-1991: ------------------------------------ Summary: GROUP BY pushdown into subselect of UNIONs Key: TEIID-1991 URL: https://issues.jboss.org/browse/TEIID-1991 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Mark Addleman Assignee: Steven Hawkins Attachments: plan.txt If have a query of the form SELECT a FROM ( SELECT a FROM ( SELECT a FROM ds.t1 ) u ) t GROUP BY a Teiid correctly optimizes the inner SELECT to SELECT 1 FROM ds.t1. However, if the inner subselect is a union: SELECT a FROM ( SELECT a FROM ( SELECT a FROM ds.t1 UNION SELECT a FROM ds.t2 ) u ) t GROUP BY a Teiid does not optimize to SELECT 1 FROM ds.t1 UNION SELECT 1 FROM ds.t2 as I would expect. See attached plan -- 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, 5 months

2
16
0 / 0

[JBoss JIRA] Created: (TEIID-1022) Index metadata should not treat cardinality 0 as unknown

by Steven Hawkins (JIRA)

Index metadata should not treat cardinality 0 as unknown -------------------------------------------------------- Key: TEIID-1022 URL: https://jira.jboss.org/jira/browse/TEIID-1022 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.1 The default cardinality is currently 0, which is treated as unknown, however it would be better if the default were something like -1 instead. This will require introducing a new index file version (so that older vdbs with a value of 0 can be understood as meaning unknown) and updating the teiid/designer metadata defaults for cardinality as -1. -- 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

12 years, 5 months

3
3
0 / 0

[JBoss JIRA] (TEIID-2125) Deploy multiple Web Service sources fails

by Mark Drilling (JIRA)

Mark Drilling created TEIID-2125: ------------------------------------ Summary: Deploy multiple Web Service sources fails Key: TEIID-2125 URL: https://issues.jboss.org/browse/TEIID-2125 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 8.1 Reporter: Mark Drilling Assignee: Steven Hawkins Attempt to deploy multiple Web Service, Salesforce or other jca sources fails. See log file with exception attached. -- 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, 5 months

3
4
0 / 0

[JBoss JIRA] (TEIID-1953) Greenplum DB - BQT correlated subquery failures

by Warren Gibson (JIRA)

Warren Gibson created TEIID-1953: ------------------------------------ Summary: Greenplum DB - BQT correlated subquery failures Key: TEIID-1953 URL: https://issues.jboss.org/browse/TEIID-1953 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 7.6 Reporter: Warren Gibson Assignee: Steven Hawkins Testing Greenplum DB against Teiid 7.6.0 Final. Greenplum DB is returning the following on 59 BQT queries: Remote org.postgresql.util.PSQLException: ERROR: Greenplum Database does not yet support that query. Detail: The query contains a correlated subquery. I am using the postgresql Translator. A couple example queries are listed below: SELECT INTKEY, STRINGNUM FROM BQT1.SmallA AS A WHERE NOT (EXISTS (SELECT STRINGNUM FROM BQT1.SmallA AS B WHERE B.INTKEY = A.INTKEY)) SELECT INTKEY, STRINGKEY FROM BQT1.SMALLA AS A WHERE STRINGKEY = (SELECT MASTRINGKEY) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY, STRINGKEY -- 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, 5 months

2
3
0 / 0

[JBoss JIRA] (TEIID-1966) supportsInCriteria is ignored

by Michal Navrkal (JIRA)

Michal Navrkal created TEIID-1966: ------------------------------------- Summary: supportsInCriteria is ignored Key: TEIID-1966 URL: https://issues.jboss.org/browse/TEIID-1966 Project: Teiid Issue Type: Bug Affects Versions: 7.7.1 Environment: Win7 Reporter: Michal Navrkal Assignee: Steven Hawkins SQL query whose WHERE clause contains ORed conditions is sent down to custom translator as IN clause even when the custom translator doesn' support IN clause. public class EWSExecutionFactory extends ExecutionFactory<ConnectionFactory, EWSConnection> { ... @Override public boolean supportsInCriteria() { return false; } @Override public boolean supportsInCriteriaSubquery() { return false; } } SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA = '2D03' OR Storage.MVDETAIL.CUA = '2D07' is translated to SELECT COUNT(*) FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA IN ('2D03', '2D07') -- 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, 5 months

2
6
0 / 0

[JBoss JIRA] (TEIID-1839) Redo the weather example

by Steven Hawkins (Created) (JIRA)

Redo the weather example ------------------------ Key: TEIID-1839 URL: https://issues.jboss.org/browse/TEIID-1839 Project: Teiid Issue Type: Task Components: Documentation Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6 Currently soap access through the weather example doesn't work (after updating the url rest works fine) due to service changes. However rather than relying on an external service, we should include in the web services example a war for AS deployment. -- 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, 5 months

4
5
0 / 0

[JBoss JIRA] (TEIID-1936) Make it straight-forward for translators to cache their metadata

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1936: ------------------------------------- Summary: Make it straight-forward for translators to cache their metadata Key: TEIID-1936 URL: https://issues.jboss.org/browse/TEIID-1936 Project: Teiid Issue Type: Enhancement Components: Connector API Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.7 The MetadataFactory passed to obtain metadata from translators does not make it easy for the translator to supply cached metadata. There should be a -- 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, 5 months

1
3
0 / 0

[JBoss JIRA] (TEIID-2137) NPE in ExecutionContext.getCommandContext()

by Andriy Rokhmanov (JIRA)

Andriy Rokhmanov created TEIID-2137: --------------------------------------- Summary: NPE in ExecutionContext.getCommandContext() Key: TEIID-2137 URL: https://issues.jboss.org/browse/TEIID-2137 Project: Teiid Issue Type: Bug Affects Versions: 8.1 Environment: Java(TM) SE Runtime Environment (build 1.7.0_05-b05) , Windows 7, Teiid 8.1.CR1 Reporter: Andriy Rokhmanov Assignee: Steven Hawkins Attachments: server.log.txt I start 10 simultaneous continuous executions against my custom ResultSetExecution translator. This piece of code causes NPE once per several seconds: public void execute() throws TranslatorException { ... CommandContext ctx = executionContext.getCommandContext(); ... } Exception dump from server.log attached. -- 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, 5 months

2
5
0 / 0

[JBoss JIRA] (TEIID-1955) Update to workwith JBoss AS Final 7.1

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-1955: ----------------------------------- Summary: Update to workwith JBoss AS Final 7.1 Key: TEIID-1955 URL: https://issues.jboss.org/browse/TEIID-1955 Project: Teiid Issue Type: Task Components: Build/Kits Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.0 Update the Teiid trunk build to use the JBoss AS 7.1.0-Final -- 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, 5 months

2
3
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2012