March 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1961) A translator override that is not used by a physical model will cause an exception on the server when the vdb is deployed

by Van Halbert (JIRA)

Van Halbert created TEIID-1961: ---------------------------------- Summary: A translator override that is not used by a physical model will cause an exception on the server when the vdb is deployed Key: TEIID-1961 URL: https://issues.jboss.org/browse/TEIID-1961 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins A previously created translator override was not associated with any physical model during the vdb development process. However, the following error occurred on the server when the vdb was deployed: org.jboss.deployers.spi.DeploymentException: The parent translator defined not found in configuration "vfszip:/Users/vhalbert/RedHat/platforms/soa/5.3/jboss-soa-p-5-object/jboss-as/server/default/deploy/Trade.vdb/" at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:102) at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:60) >From a usability standpoint, the user shouldn't need to remove translator overrides that are not currently used because they represent a what-if scenario the user is trying and may contain override info they are not done with. The server should just ignore those that are not used. Also, it would be good if the error message indicated the name of the translator/override it was having issues with. -- 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, 4 months

2
7
0 / 0

[JBoss JIRA] (TEIID-1893) TeiidException when executing SELECT subquery with more than 2 UNIONs

by Andriy Rokhmanov (Created) (JIRA)

TeiidException when executing SELECT subquery with more than 2 UNIONs --------------------------------------------------------------------- Key: TEIID-1893 URL: https://issues.jboss.org/browse/TEIID-1893 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Environment: Windows 7, JBoss 5.1.0.GA, java version "1.6.0_22" 64 bit Reporter: Andriy Rokhmanov Assignee: Steven Hawkins Exception: org.teiid.core.TeiidException happens after executing select statement #1, but works fine on #2 and #3. The execution plan for problematic statement attached. 1. Problematic SQL Statement: SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'demodata_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME AND T.install_status = true; 2. This SQL statement works fine (the difference between #1 and #2 is in final 'AND...' clause): SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'demodata_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME; 3. This SQL statement also works fine (the difference between #1 and #3 is only two UNIONs included out of three, does not matter which ones) SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME AND T.install_status = true; -- 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, 4 months

5
4
0 / 0

[JBoss JIRA] (TEIID-1983) BaseDelegatingTranslator should delegate properties from setSupports* methods

by Mark Addleman (JIRA)

Mark Addleman created TEIID-1983: ------------------------------------ Summary: BaseDelegatingTranslator should delegate properties from setSupports* methods Key: TEIID-1983 URL: https://issues.jboss.org/browse/TEIID-1983 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Mark Addleman Assignee: Steven Hawkins For details see https://community.jboss.org/message/726417#726417 -- 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, 4 months

2
2
0 / 0

[JBoss JIRA] (TEIID-1865) Thread-safe JDBC connection

by Mark Addleman (Created) (JIRA)

Thread-safe JDBC connection --------------------------- Key: TEIID-1865 URL: https://issues.jboss.org/browse/TEIID-1865 Project: Teiid Issue Type: Feature Request Reporter: Mark Addleman Assignee: Steven Hawkins I would like to share an embedded Teiid JDBC connection across multiple threads without the JDBC client worrying about synchronization. For more detail, see forum discussion http://community.jboss.org/message/641133#641133 -- 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, 4 months

2
3
0 / 0

[JBoss JIRA] (TEIID-1874) Add metadata validation for dynamic vdb imported metadata

by Steven Hawkins (Created) (JIRA)

Add metadata validation for dynamic vdb imported metadata --------------------------------------------------------- Key: TEIID-1874 URL: https://issues.jboss.org/browse/TEIID-1874 Project: Teiid Issue Type: Quality Risk Components: Connector API Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 If incomplete metadata is returned to the engine downstream errors occur that are unclear in origin. At the very least we need to validate column/type informaiton. -- 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, 4 months

2
3
0 / 0

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

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

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

4
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2012