March 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-838) Runtime discovery of VDBs

by Steve Jacobs (JIRA)

Runtime discovery of VDBs ------------------------- Key: TEIID-838 URL: https://jira.jboss.org/jira/browse/TEIID-838 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Steve Jacobs Assignee: Steven Hawkins Teiid server should be able to discover VDBs at runtime and automatically load them to the extent possible - i.e. if the server is not configured to require entitlements and all connectors are running, the server should load the VDB as a new version and allow queries. -- 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

15 years, 9 months

5
6
0 / 0

[JBoss JIRA] Created: (TEIID-945) WS security tokens are configured but not provided to the service.

by John Doyle (JIRA)

WS security tokens are configured but not provided to the service. ------------------------------------------------------------------ Key: TEIID-945 URL: https://jira.jboss.org/jira/browse/TEIID-945 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 6.2.0 Reporter: John Doyle Assignee: John Doyle Fix For: 7.0 See secToken in com.metamatrix.connector.xml.soap.SOAPRequest. It's never used. -- 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

15 years, 9 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-936) Query never returns from processing

by Paul Nittel (JIRA)

Query never returns from processing ----------------------------------- Key: TEIID-936 URL: https://jira.jboss.org/jira/browse/TEIID-936 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Environment: fedora 12, Teiid build 1/19/2010, OpenJDK Server VM (build 14.0-b16, mixed mode) Reporter: Paul Nittel Assignee: Steven Hawkins I'm executing TPCR Query #16. It processes correctly, and very quickly, in Designer, which is using an older Teiid query engine. The current Teiid, running via AdminShell, never returns from this query. Both are using the same VDB. Two tables are involved PART (200,000 rows) and PARTSUPP (800,000 rows). The output will contain 18,314 rows. The transformation query is: SELECT P_BRAND, P_TYPE, P_SIZE, COUNT(DISTINCT PS_SUPPKEY) AS supplier_cnt FROM TPCR.PARTSUPP, TPCR.PART WHERE (P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%') AND (P_SIZE IN (49, 14, 23, 45, 19, 3, 36, 9)) AND (PS_SUPPKEY NOT IN (SELECT S_SUPPKEY FROM TPCR.SUPPLIER WHERE S_COMMENT LIKE '%Customer%Complaints%')) GROUP BY P_BRAND, P_TYPE, P_SIZE The query being executed is: select * from vTpcr.Q16 ORDER BY supplier_cnt desc, p_brand, p_type, p_size I have tried to execute shorter version of the transformation query in AdminShell to no avail. This query: SELECT P_BRAND, P_TYPE, P_SIZE FROM TPCR.PARTSUPP, TPCR.PART WHERE (P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%'); did not return in a reasonable time. Teiid seems to use a fair percentage of the CPU for a while, then usage drops to ~0.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

15 years, 9 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-1004) Check for common math exceptions

by Steven Hawkins (JIRA)

Check for common math exceptions -------------------------------- Key: TEIID-1004 URL: https://jira.jboss.org/jira/browse/TEIID-1004 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.0 Rather than returning NaN or +-Infinity, it would be best for Teiid to throw an exception for float/double divide by zero, log of a non-positive value, etc. -- 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

15 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1002) Remove unnecessary sandbox connectors

by Steven Hawkins (JIRA)

Remove unnecessary sandbox connectors ------------------------------------- Key: TEIID-1002 URL: https://jira.jboss.org/jira/browse/TEIID-1002 Project: Teiid Issue Type: Task Components: Connector API Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.0 We should consider removing all sandbox connectors. For most the object connector should be removed as it is now out-of-date. -- 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

15 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-909) PropertiesUtils.resolveNestedProperties(Properties) goes in a loop

by Van Halbert (JIRA)

PropertiesUtils.resolveNestedProperties(Properties) goes in a loop ------------------------------------------------------------------- Key: TEIID-909 URL: https://jira.jboss.org/jira/browse/TEIID-909 Project: Teiid Issue Type: Bug Components: Common Affects Versions: 7.0 Reporter: Van Halbert Assignee: Van Halbert Fix For: 7.0 The resolveNestedProperties logic goes in a loop when the key is also in the value as ${key}. Example of what caused the problem was: key= usedatasources value=${usedatasources} -- 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

15 years, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-862) Teiid engine needs to be exposed as a JCA Connector

by Ramesh Reddy (JIRA)

Teiid engine needs to be exposed as a JCA Connector --------------------------------------------------- Key: TEIID-862 URL: https://jira.jboss.org/jira/browse/TEIID-862 Project: Teiid Issue Type: Sub-task Components: Embedded, Server Affects Versions: 6.3 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 6.3 DQPCore, which is the main interface for the Teiid engine must be available as a JCA source that is capable of engaging multiple other JCA sources in a data integration solution. This should leverage the "Work Manager" for carrying out any tasks. -- 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

15 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-918) Change all package names to org.teiid

by Steven Hawkins (JIRA)

Change all package names to org.teiid ------------------------------------- Key: TEIID-918 URL: https://jira.jboss.org/jira/browse/TEIID-918 Project: Teiid Issue Type: Quality Risk Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.0 With a major version switch we should change our packages over to teiid. This will need to be coordinated with the designer as well. -- 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

15 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-947) UNION query with different datatypes on each side of UNION is producing inconsistent results

by Warren Gibson (JIRA)

UNION query with different datatypes on each side of UNION is producing inconsistent results --------------------------------------------------------------------------------------------- Key: TEIID-947 URL: https://jira.jboss.org/jira/browse/TEIID-947 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Warren Gibson Assignee: Steven Hawkins The following query is producing unexpected results in CTC. It is not consistent and sometimes produces unexpected results and sometimes passes. However, it can be reproduced. SELECT IntKey, IntNum FROM BQT1.SmallA UNION SELECT StringKey, StringNum FROM BQT2.MediumB ORDER BY IntKey The datatypes of each side of the union are not the same and sometimes rmdata.getColumnTypeName(++col) indicates its a string and sometimes it says its an integer. It is my understanding that the column should be implicitly converted to a consistent type (in this case a string). -- 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

15 years, 9 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-891) Add JDBC import logic to correct unsigned types

by Steven Hawkins (JIRA)

Add JDBC import logic to correct unsigned types ----------------------------------------------- Key: TEIID-891 URL: https://jira.jboss.org/jira/browse/TEIID-891 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.0 SQLServer/MySQL and other dbs have support for unsigned types. We should be able to import these types as a wider type to ensure that we can access the values. -- 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

15 years, 9 months

2
2
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2010