November 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-756) Oracle Connector is not producing the correct queries when using a LIMIT clause

by Larry O'Leary (JIRA)

Oracle Connector is not producing the correct queries when using a LIMIT clause ------------------------------------------------------------------------------- Key: TEIID-756 URL: https://jira.jboss.org/jira/browse/TEIID-756 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.1.0, 6.0.0, 6.2.0 Reporter: Larry O'Leary Assignee: Steven Hawkins When using a LIMIT clause in a query, the Oracle Connector rewrites it to something that Oracle will understand. The problem is that the rewritten version of the query is not returning the expected results. For example: SELECT INTKEY FROM BQT1.MEDIUMA LIMIT 50, 100 Should return 50 rows starting at row 100 but instead returns 0 rows when executed via the Oracle Connector. Currently the above query is rewritten as: SELECT * FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (SELECT MediumA.IntKey FROM MediumA) VIEW_FOR_LIMIT WHERE ROWNUM <= 150) WHERE ROWNUM_ > 50 Further more, the rewritten version of the query is also projecting a column named ROWNUM_ which would be invalid based on our query processing. -- 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, 6 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-775) Backwards scrolling defect

by Steven Hawkins (JIRA)

Backwards scrolling defect -------------------------- Key: TEIID-775 URL: https://jira.jboss.org/jira/browse/TEIID-775 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Iterating backwards does not work the since RequestWorkItem is setup to expect the end row as greater than the start row. It would be much simpler if the client were changed to issue the batch bounds with the lower value as the begin row. Clients may not have noticed this issue since they would have to do iteration beyond the third batch and then go backwards three batches. -- 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, 6 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-759) XQuery parameter evaluation fails

by Steven Hawkins (JIRA)

XQuery parameter evaluation fails --------------------------------- Key: TEIID-759 URL: https://jira.jboss.org/jira/browse/TEIID-759 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Non-constant xquery parameter evaluation is failing since the commandcontext is not used for the expression evaluation. -- 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, 6 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-755) Oracle Connector is not honouring metadata when rewriting ORDER BY clause

by Larry O'Leary (JIRA)

Oracle Connector is not honouring metadata when rewriting ORDER BY clause ------------------------------------------------------------------------- Key: TEIID-755 URL: https://jira.jboss.org/jira/browse/TEIID-755 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.1.0, 6.0.0, 6.2.0 Reporter: Larry O'Leary Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 When executing a query that contains an ORDER BY clause, the Oracle Connector is rewriting the query using the column name given by the MM query rather than the source name as specified in the source model. What this means is that column name case is not being enforced. For example: MM User Command: SELECT INTKEY FROM BQT1.SMALLA UNION SELECT INTKEY FROM BQT1.SMALLB ORDER BY INTKEY Model represents INTKEY as IntKey for source name. Currently we rewrite as: SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY INTKEY This should actually be: SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY IntKey Although this does not trigger a failure with the current implementation, if the column names were qualified is SQL identifiers, the query would fail as Oracle is expecting a column name of "IntKey" and would not know what "INTKEY" was. -- 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, 6 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-758) Add locate function support to postgres

by Steven Hawkins (JIRA)

Add locate function support to postgres --------------------------------------- Key: TEIID-758 URL: https://jira.jboss.org/jira/browse/TEIID-758 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 6.2.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Optional Fix For: 6.2.0 Add support for locate to the postgresql translator. The 2 arg form is trival, but just as their jdbc escape docs indicate the 3 arg version needs more effort. For our purposes we'll use position('sub' in substr('string', fromIndex)). See TEIID-754 for possibly adding logic on the from index to ensure consistency with values less than 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

14 years, 6 months

2
2
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, 8 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, 8 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, 8 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-713) JDBC Connector deregistration logic is incorrect.

by Steven Hawkins (JIRA)

JDBC Connector deregistration logic is incorrect. ------------------------------------------------- Key: TEIID-713 URL: https://jira.jboss.org/jira/browse/TEIID-713 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 The current deregistration logic is checking the wrong classloader. It should be using the context class loader to compare against the driver's classloader. -- 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

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-720) Translate criteria validation issues

by Steven Hawkins (JIRA)

Translate criteria validation issues ------------------------------------ Key: TEIID-720 URL: https://jira.jboss.org/jira/browse/TEIID-720 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Translate criteria should not accept criteria containing an OR, since the logic assumes that it can always use predicates independently (or worse the current logic would turn an OR into an AND). Also the validation check needs to check each user predicate and not exit early if a particular criteria type is not being translated. -- 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

1
2
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2009