January 2012 - teiid-issues - Jboss List Archives

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

[JBoss JIRA] (TEIID-1798) Document to show how the CXF configuration file can be configured for Web-Service source

by Ramesh Reddy (Created) (JIRA)

Document to show how the CXF configuration file can be configured for Web-Service source ---------------------------------------------------------------------------------------- Key: TEIID-1798 URL: https://issues.jboss.org/browse/TEIID-1798 Project: Teiid Issue Type: Task Components: Documentation Affects Versions: 7.5 Reporter: Ramesh Reddy Fix For: 7.6 Document how to use the CXF configuration file to define the timeout settings and ws-security settings for a web-service. The csf file is like below <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:http-conf="http://cxf.apache.org/transports/http/configuration" xsi:schemaLocation="http://cxf.apache.org/transports/http/configuration http://cxf.apache.org/schemas/configuration/http-conf.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <http-conf:conduit name="{http://teiid.org}teiid.http-conduit"> <http-conf:client ConnectionTimeout="120000" ReceiveTimeout="240000"/> </http-conf:conduit> </beans> Note the conduit name {http://teiid.org}teiid.http-conduit. For WS adapters we currently hardcode the namespace of http://teiid.org. But you can set the local name xxx.http-conduit based upon the configName setting. Add this example to the admin guide. http://cxf.apache.org/docs/configuration.html -- 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
2
0 / 0

[JBoss JIRA] (TEIID-1788) Type/sizing improvements

by Steven Hawkins (Created) (JIRA)

Type/sizing improvements ------------------------ Key: TEIID-1788 URL: https://issues.jboss.org/browse/TEIID-1788 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins The typing and batch sizing logic is burdensome to bulk data loads into temp tables. -- 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
5
0 / 0

[JBoss JIRA] (TEIID-1846) Update or delete against a instead of trigger with an access pattern fails

by Steven Hawkins (Created) (JIRA)

Update or delete against a instead of trigger with an access pattern fails -------------------------------------------------------------------------- Key: TEIID-1846 URL: https://issues.jboss.org/browse/TEIID-1846 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.6 Update or delete against a instead of trigger with an access pattern fails because the original command (attached to the plan as atomic_request) is modified by trigger action planning. -- 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
2
0 / 0

[JBoss JIRA] Created: (TEIID-1614) Embedded connections using the calling thread can hang

by Steven Hawkins (JIRA)

Embedded connections using the calling thread can hang ------------------------------------------------------ Key: TEIID-1614 URL: https://issues.jboss.org/browse/TEIID-1614 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.4.1 The pause logic allows for another engine thread to run in the place of the calling thread, which leaves the calling thread basically hung. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
4
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2012