August 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1959) Add a way to exclude tables/procedures from JDBC import

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1959: ------------------------------------- Summary: Add a way to exclude tables/procedures from JDBC import Key: TEIID-1959 URL: https://issues.jboss.org/browse/TEIID-1959 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins The JDBC importer provides a simplistic pass-through for table/procedure inclusion, but that can make it cumbersome to exclude a small subset of tables/procedures. -- 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

1
3
0 / 0

[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-2026) Teiid configuration varibles are not writable

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2026: ----------------------------------- Summary: Teiid configuration varibles are not writable Key: TEIID-2026 URL: https://issues.jboss.org/browse/TEIID-2026 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.1 Currently all the attribute variables under Teiid subsystem are read-only, they can not be modified using the CLI. -- 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-2152) MERGE support

by Mark Addleman (JIRA)

Mark Addleman created TEIID-2152: ------------------------------------ Summary: MERGE support Key: TEIID-2152 URL: https://issues.jboss.org/browse/TEIID-2152 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Mark Addleman Assignee: Steven Hawkins -- 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

1
1
0 / 0

[JBoss JIRA] (TEIID-1845) Cache hint not being displayed after validation of Virtual Procedure in JBoss Developer Studio

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1845?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1845. --------------------------------- > Cache hint not being displayed after validation of Virtual Procedure in JBoss Developer Studio > ---------------------------------------------------------------------------------------------- > > Key: TEIID-1845 > URL: https://issues.jboss.org/browse/TEIID-1845 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.2 > Environment: JBoss Developer Studio 4.0 > JBoss Developer Studio 4.1 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Priority: Minor > Fix For: 7.6 > > > /*+ cache */ > CREATE VIRTUAL PROCEDURE > BEGIN > SELECT 'winning'; > END > The cache hint is saved w/the Command Object even though it is not reflected in the display of the text after validation. > com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent:313 & 314 > The Command object on these lines has a member cacheHint, holding the reference to the cacheHint, this is ignored when the sqlText is set with the line: > this.sqlText = sqlDisplayNode.toDisplayString(); -- 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

1
0
0 / 0

[JBoss JIRA] (TEIID-1988) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-1988: ------------------------------------ Summary: Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top Key: TEIID-1988 URL: https://issues.jboss.org/browse/TEIID-1988 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Johnathon Lee Assignee: Steven Hawkins Fix For: 7.7, 8.0 Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log, TPC.vdb When running the following query, it causing an ASSERTION (see attached log): SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY) AND (ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL < 9514.5)) AS T Note: this doesn't fail when SELECT COUNT(*) isn't used -- 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
15
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

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2012