October 2011 - teiid-issues - Jboss List Archives

[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, 4 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, 4 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, 4 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1597) Index metadata issues

by Steven Hawkins (JIRA)

Index metadata issues --------------------- Key: TEIID-1597 URL: https://issues.jboss.org/browse/TEIID-1597 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Using index metadata will cause multisource usage of procedures to always fail and not allow xml staging tables to be referenced by user queries. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1586) Increase audit information

by Steven Hawkins (JIRA)

Increase audit information -------------------------- Key: TEIID-1586 URL: https://issues.jboss.org/browse/TEIID-1586 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins AuditMessages should include the Session object and the request id, so that custom logging can access additional information. login events should also capture more detail including IP (and possibly MAC), etc. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
4
0 / 0

[JBoss JIRA] Created: (TEIID-1677) Exists subqueries will unnest by default

by Steven Hawkins (JIRA)

Exists subqueries will unnest by default ---------------------------------------- Key: TEIID-1677 URL: https://issues.jboss.org/browse/TEIID-1677 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Exists subqueries should respect the default unnest property, rather than always unnesting. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1639) Unable to build on a file system that isn't formatted to support case-sensitivity

by Van Halbert (JIRA)

Unable to build on a file system that isn't formatted to support case-sensitivity --------------------------------------------------------------------------------- Key: TEIID-1639 URL: https://issues.jboss.org/browse/TEIID-1639 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 7.4, 7.4.1 Reporter: Van Halbert Assignee: Van Halbert Priority: Critical Trying to build the 7.4.1 branch and trunk, but unable to due to the metadata project contains 2 vdb files; Test.vdb and test.vdb in the the src/test/resources directory. Each are for different tests. This problem is due to a filesystem hasn't been formatted to support case-sensititivity. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic

by Van Halbert (JIRA)

Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic ----------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1632 URL: https://issues.jboss.org/browse/TEIID-1632 Project: Teiid Issue Type: Feature Request Components: Server Affects Versions: 7.4 Reporter: Van Halbert Assignee: Steven Hawkins Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-1625) SalesForce INCLUDE function not being pushed to source

by Paul Nittel (JIRA)

SalesForce INCLUDE function not being pushed to source ------------------------------------------------------ Key: TEIID-1625 URL: https://issues.jboss.org/browse/TEIID-1625 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Environment: Models built by JBDS 4.1 CR1 Reporter: Paul Nittel Assignee: Steven Hawkins While executing the SalesForce test script I executed the following query: Select Name, Communication_Preferences__c from Contact where true = includes(Communication_Preferences__c, 'Fax,Email') Other queries do succeed, but the exclude function suffers a similar fate. The response was: Function includes is marked in the function metadata as a function that must be evaluated at the source. Looking at the functions in the Designer, the PUSH DOWN property has a value of REQUIRED. Am attaching the server log excerpt and Model Project Set -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1603) BQT Query not returning expected row count

by Warren Gibson (JIRA)

BQT Query not returning expected row count ------------------------------------------ Key: TEIID-1603 URL: https://issues.jboss.org/browse/TEIID-1603 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Environment: Running BQT Query Suite against Teiid 7.4 Reporter: Warren Gibson Assignee: Steven Hawkins Attachments: RDBMS_Test_Queries_9600_TestQuery63.xml Teiid 7.4 - the following query is returning no rows but the expected row count is 47 rows. This was tested with MySql50 and Teradata12. I verified the query produced 47 rows with SOA-P 5.1 GA. See expected query results file attached. VDB can be made available if needed. SELECT INTKEY, DATEVALUE, BYTENUM FROM BQT1.SmallA WHERE DATEVALUE <> ANY (SELECT DATEVALUE FROM BQT1.SmallA WHERE BYTENUM >= '-108') The source query from the log file is: SELECT cast(g_0.INTKEY AS signed) AS c_0, g_0.DATEVALUE AS c_1, g_0.BYTENUM AS c_2 FROM smalla AS g_0 WHERE g_0.DATEVALUE NOT IN (SELECT g_1.DATEVALUE FROM smalla AS g_1 WHERE g_1.BYTENUM >= -108) LIMIT 100 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2011