June 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-605) Push down query results different than MetaMatrix query results without push down - Oracle 11

by Warren Gibson (JIRA)

Push down query results different than MetaMatrix query results without push down - Oracle 11 ---------------------------------------------------------------------------------------------- Key: TEIID-605 URL: https://jira.jboss.org/jira/browse/TEIID-605 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Environment: Running Teiid Server on Windows CTC Query testing client on Windows Reporter: Warren Gibson Assignee: Steven Hawkins This may not be a bug but may just be a decision point to determine if MetaMatrix should guarantee the same query results as if the query was pushed down to the source. In some cases different results can be expected from different DBMS sources. 1. Running Teiid Server with Console Extension Capability Class set to default (blank). 2. Run queries against Oracle 11 source. 3. Results show many examples where "nulls" are being handled differently in a push down ORDER BY situation than what our expected results reflect. 4. Basically in the Oracle 11 situation the "nulls" are showing up in the results just opposite from what MetaMatrix does. In other words in the following query "Select BQT1.SmallA.IntNum From BQT1.SmallA ORDER BY BQT1.SmallA.IntNum DESC" push down results shows "nulls" at the beginning of results whereas without push down MetaMatrix will show the "nulls" at the end of the results. 5. See attached results from this query. -- 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

14 years, 7 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-486) MOD() scalar function should be supported by DB2 Connector

by Larry O'Leary (JIRA)

MOD() scalar function should be supported by DB2 Connector ---------------------------------------------------------- Key: TEIID-486 URL: https://jira.jboss.org/jira/browse/TEIID-486 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 6.0.0, 6.1.0 Reporter: Larry O'Leary Assignee: Steven Hawkins An issue was logged in where a function that resulted in the use of the mod() scalar function would result in a different query plan causing the queries criteria not to be pushed-down to the source. It appears the cause of the misbehaved query plan was the DB2 connector not supporting the MOD() scalar function. -- 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

14 years, 7 months

4
17
0 / 0

[JBoss JIRA] Created: (TEIID-684) Dynamic data integration feature (Integrate data with out a VDB)

by Ramesh Reddy (JIRA)

Dynamic data integration feature (Integrate data with out a VDB) ---------------------------------------------------------------- Key: TEIID-684 URL: https://jira.jboss.org/jira/browse/TEIID-684 Project: Teiid Issue Type: Feature Request Components: Connector API, Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Critical Fix For: 6.3.0 This is feature request for dynamically integrating the data with out any modelling exercise, so that any tooling is not required before you can start integrating data. Using this feature, the user would create/define a Connectors (data sources) in the Teiid runtime engine, and then user connects to runtime engine using the JDBC driver provided, then he/she can start writing SQL queries that spans multiple data sources in a single statement as if they are single source. For example: Data Source: A has TableA1 TableA2 DataSource: B has TableB1 TableB2 user can write SQL queries such as SELECT A.TableA1.e1, A.TableA1.e2, B.TableB1.e1, B.TableB1.e2 FROM A.TableA1, B.TableB1 WHERE A.TableA1.e1 = B.TableB1.e1 They can much more complex join queries than above too. -- 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

14 years, 7 months

3
6
0 / 0

[JBoss JIRA] Created: (TEIID-614) Log XML Request/Response Doc binding property = TRUE is not causing documents to be logged.

by Ken Johnson (JIRA)

Log XML Request/Response Doc binding property = TRUE is not causing documents to be logged. -------------------------------------------------------------------------------------------- Key: TEIID-614 URL: https://jira.jboss.org/jira/browse/TEIID-614 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 6.0.0 Environment: Teiid 6.0.1 + Teiid Designer 6.0.0. RHEL 5. Teiid running both in Designer (SQL Explorer) and deployed as JDBC driver in JB AS 4.2.3. Reporter: Ken Johnson Assignee: Steven Hawkins XML (relational) SOAP Connector: Setting the "Log XML Request and Response Docs" binding property to true is failing to enable logging of SOAP request and response documents. -- 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

14 years, 7 months

4
6
0 / 0

[JBoss JIRA] Created: (TEIID-496) ValueValidationVisitor needs the variable context

by Steven Hawkins (JIRA)

ValueValidationVisitor needs the variable context ------------------------------------------------- Key: TEIID-496 URL: https://jira.jboss.org/jira/browse/TEIID-496 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 Resolving parameter values no longer sets the values directly on the command. The visitor will have to follow references to determine if the values are valid. -- 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

14 years, 7 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-678) Document/test Alternative Means to Acheive Current XML Document Scenarios

by Ted Jones (JIRA)

Document/test Alternative Means to Acheive Current XML Document Scenarios ------------------------------------------------------------------------- Key: TEIID-678 URL: https://jira.jboss.org/jira/browse/TEIID-678 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 6.1.0 Reporter: Ted Jones Assignee: Steven Hawkins Fix For: 6.2.0 1. Start with an XML Schema to build a Document that can be filled with relational, heterogeneous data and "shipped around" 2. Given an XML document/message definition, submit a query on the document with criteria defined within the document structure 3. Send an input document, produce and output document -- 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

14 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-675) Document/test a Means of Bottom-up Web Services in Teiid

by Ted Jones (JIRA)

Document/test a Means of Bottom-up Web Services in Teiid -------------------------------------------------------- Key: TEIID-675 URL: https://jira.jboss.org/jira/browse/TEIID-675 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 6.1.0 Reporter: Ted Jones Assignee: Ted Jones Fix For: 6.2.0 -- 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

14 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-674) Document/test a Means of Top-down WSDL Consumption

by Ted Jones (JIRA)

Document/test a Means of Top-down WSDL Consumption -------------------------------------------------- Key: TEIID-674 URL: https://jira.jboss.org/jira/browse/TEIID-674 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 6.1.0 Reporter: Ted Jones Assignee: Steven Hawkins Fix For: 6.2.0 -- 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

14 years, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-610) Deleted connector bindings remain in the system state

by Steven Hawkins (JIRA)

Deleted connector bindings remain in the system state ----------------------------------------------------- Key: TEIID-610 URL: https://jira.jboss.org/jira/browse/TEIID-610 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.1.1 If a connector binding is first stopped and then removed, it remains in the system state (but is otherwise removed from the system). -- 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

14 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-608) Prevent duplicate hostcontroller launches

by Steven Hawkins (JIRA)

Prevent duplicate hostcontroller launches ----------------------------------------- Key: TEIID-608 URL: https://jira.jboss.org/jira/browse/TEIID-608 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 6.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.1.0 Even if the hostcontroller persistent process is removed, we still need to ensure that multiple attempts to launch processes works well. The worst issue right now is that the log of the original hostconroller will be replaced with the new (which then immediately exits). See also TEIID-601 -- 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

14 years, 9 months

2
5
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2009