March 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1352) Produce Admin API jar containing only Interfaces.

by John Doyle (JIRA)

Produce Admin API jar containing only Interfaces. ------------------------------------------------- Key: TEIID-1352 URL: https://jira.jboss.org/browse/TEIID-1352 Project: Teiid Issue Type: Feature Request Components: AdminApi Reporter: John Doyle Assignee: Steven Hawkins TEIIDDES-175 requires the creation of a target runtime for Teiid so that the tooling can be further abstracted from changes in Teiid. In order to accomplish this the tooling requires an Admin API jar containing only interfaces. The Designer code that depends upon the Admin API could be compiled with this jar, and the plug-in defining the target runtime would load the implementation of the Admin API at runtime. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 7 months

7
11
0 / 0

[JBoss JIRA] Created: (TEIID-1268) Add support for using the case insensitive metadata

by Steven Hawkins (JIRA)

Add support for using the case insensitive metadata --------------------------------------------------- Key: TEIID-1268 URL: https://jira.jboss.org/browse/TEIID-1268 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 We currently capture whether the source is case sensitive and thus have a place holder on both physical and virtual models, but we do not use this information in performing comparisons in teiid. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1465) Join between char and varchar

by Claudio Venturini (JIRA)

Join between char and varchar ----------------------------- Key: TEIID-1465 URL: https://issues.jboss.org/browse/TEIID-1465 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Environment: Teiid 7.3 deployed on Jboss AS 5.1.0 GA running on Ubuntu Server 10.04 LTS, MySQL 5.1.51 running on the same machine as JBoss, SQL Server 2000 Standard SP4 running on Windows Server 2003 Reporter: Claudio Venturini Assignee: Steven Hawkins Joins between char and varchar fields fail. Suppose to have a table T1 with a field A, declared as char(10), and a table T2 with a field B, declared as varchar(10). Suppose that the two tables have the following data. *T1*: ||A|| |ML0001| *T2*: ||B|| |ML0001| When performing a INNER JOIN with the condition {{T1.A = T2.B}} the result set is empty, even if the two record match correctly. This happens when the two base tables refer to two different sources, because if they are in the same source Teiid pushes the join to the source, which computes it correctly. I think the problem is in the comparison of the two strings. I have the table T1 in SQL Server 2000, and the table T2 in MySQL 5.1. If one asks SQL Server to convert the string to bytes, the result is {{0x4D4C3030303120202020}}, because the string is filled with (invisible) blanks in order to reach the limit of 10 characters. Note that if one asks for the length of that string, SQL Server states (correctly) that it is 6 characters. The string in MySQL is a VARCHAR(10), so its conversion to binary is {{0x4D4C30303031}}. I think that Teiid compares the two binary strings in their entire length. That comparison fails, and no match is found. The problem remains even if the table T1 is placed in MySQL, and T2 in SQL Server (the opposite situation). I also verified that the problem exists either when querying the source models or view models built over them. *Workaround:* A workaround exists but it is too complex (IMHO). I haven't tested it with many records, but I think it will slow down performances considerably. It consists in casting the string from char to varchar, and then trimming it (with RTRIM() and LTRIM() because SQL Server doesn't support TRIM()). So the join condition is: {noformat} RTRIM(LTRIM(CAST(T1.A AS VARCHAR))) = T2.B {noformat} -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
8
0 / 0

[JBoss JIRA] Created: (TEIID-1528) ruleimplementjoin strategy may generate an order by that does not use a relevant index

by Steven Hawkins (JIRA)

ruleimplementjoin strategy may generate an order by that does not use a relevant index -------------------------------------------------------------------------------------- Key: TEIID-1528 URL: https://issues.jboss.org/browse/TEIID-1528 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins If a table is given additional join criteria not covered by an index or if a composite key is being used ruleimplementjoinstrategy may - either add an item not covered by the index to the order by or not use the proper order of the index columns. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
6
0 / 0

[JBoss JIRA] Created: (TEIID-1448) XMLTABLE processing should support streaming when possible

by Steven Hawkins (JIRA)

XMLTABLE processing should support streaming when possible ---------------------------------------------------------- Key: TEIID-1448 URL: https://issues.jboss.org/browse/TEIID-1448 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Just like the old xml/relational processing if the xpaths/xquery used is sufficiently restrictive the xml can be processed in a streaming fashion - where independent siblings are processed independently without loading the rest of the document. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
4
0 / 0

[JBoss JIRA] Created: (TEIID-1507) Cache invalidation

by Steven Hawkins (JIRA)

Cache invalidation ------------------ Key: TEIID-1507 URL: https://issues.jboss.org/browse/TEIID-1507 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins We should provide an interface and internally react to events of updates to vdbname/version/table/row and purge resultset cache and possibly materialization. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1536) Local connections should use calling thread

by Steven Hawkins (JIRA)

Local connections should use calling thread ------------------------------------------- Key: TEIID-1536 URL: https://issues.jboss.org/browse/TEIID-1536 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 locsl connections block on jdbc operations, but mostly do not use the calling thread in the engine. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1495) Validate the TeraData Translator

by Ramesh Reddy (JIRA)

Validate the TeraData Translator -------------------------------- Key: TEIID-1495 URL: https://issues.jboss.org/browse/TEIID-1495 Project: Teiid Issue Type: Task Components: JDBC Connector Affects Versions: 7.3 Reporter: Ramesh Reddy Fix For: 7.4 Currently the Teiid does provide a Teradata translator, however it has been taken from the old MMX code, however it was never validated with Teiid to make sure this works correctly with the data source. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1323) Add support for pushdown of non-literal procedure parameter expressions.

by Steven Hawkins (JIRA)

Add support for pushdown of non-literal procedure parameter expressions. ------------------------------------------------------------------------ Key: TEIID-1323 URL: https://jira.jboss.org/browse/TEIID-1323 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 We are forcing all push-down procedure arguments to be literals (for simplicity), when all expressions should be allowed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 1 month

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1450) The weather example test queries for SOAP/REST are unexecutable, as is, in README.txt file.

by Van Halbert (JIRA)

The weather example test queries for SOAP/REST are unexecutable, as is, in README.txt file. ------------------------------------------------------------------------------------------- Key: TEIID-1450 URL: https://issues.jboss.org/browse/TEIID-1450 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 7.1.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Blocker The test queries in the README.txt are invalid for execution, as is. And when the new line and tab characters are removed, they still don't work. Need queries that can be cut and pasted (without editing) for a RHEL OS shell script. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 1 month

4
7
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2011