May 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Updated: (TEIID-1485) Virtual Procedures validator will not correctly validate whether access patterns are satisfied, resulting in run-time errors

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1485?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1485: ---------------------------------- Affects Version/s: 6.0.0 Priority: Minor (was: Major) Description: Create a table that has an access pattern. Then create a virtual procedure that selects data from the table, but does not satisfy the access pattern. Validate the procedure -- it will validate successfully. We should catch access pattern errors during validation. Instead, this results in run-time errors. See attached screenshot for an example. was: Create a table that has an access pattern. Then create a virtual procedure that selects data from the table, but does not satisfy the access pattern. Validate the procedure -- it will validate successfully. This is a bug. We should catch access pattern errors during validation. Instead, this results in run-time errors. See attached screenshot for an example. Component/s: Query Engine This was moved from the designer since the validation of access patterns is performed in Teiid. Other than the simple case shown in this issue it is generally hard to determine if an access pattern will be violated when contained under view layers and with complex predicates. A possible validation could simply check only if there is sufficient (but to not actually assess pushdown) criteria against a physical table. > Virtual Procedures validator will not correctly validate whether access patterns are satisfied, resulting in run-time errors > ---------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1485 > URL: https://issues.jboss.org/browse/TEIID-1485 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Michael Walker > Priority: Minor > Attachments: novalidation.JPG > > > Create a table that has an access pattern. Then create a virtual procedure that selects data from the table, but does not satisfy the access pattern. Validate the procedure -- it will validate successfully. > We should catch access pattern errors during validation. Instead, this results in run-time errors. > See attached screenshot for an example. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1494) Allow the optional join hint to work with non-ansi joins

by Steven Hawkins (JIRA)

Allow the optional join hint to work with non-ansi joins -------------------------------------------------------- Key: TEIID-1494 URL: https://issues.jboss.org/browse/TEIID-1494 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The optional join hint currently works only in ansi joins, and then only if the table(s) are not used in where predicates forcing unnatural on clauses. e.g. select b.* from /*+optional*/ a, b where a.x = b.x should still allow a to be optional. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
3
0 / 0

[JBoss JIRA] Closed: (TEIID-1444) Jopr Plugin has description for refreshing Materialized Views that's awkward: "Refresh a given any Materialized View for this VDB"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1444?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1444. --------------------------------- > Jopr Plugin has description for refreshing Materialized Views that's awkward: "Refresh a given any Materialized View for this VDB" > ---------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1444 > URL: https://issues.jboss.org/browse/TEIID-1444 > Project: Teiid > Issue Type: Bug > Components: Jopr Plugin > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Steven Hawkins > Priority: Minor > Fix For: 7.3 > > > On the VDB page, the JOPR description for the "Refresh a Materialized View" action says, "Refresh a given any Materialized View for this VDB". It should probably say something like, "Refresh a specified Materialized View for this VDB". -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1496) disjunctive rewrite

by Steven Hawkins (JIRA)

disjunctive rewrite ------------------- Key: TEIID-1496 URL: https://issues.jboss.org/browse/TEIID-1496 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 for better index usage, something like col = 1 or col = 2 should be rewriten as col in (1, 2) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1493) In a cluster the distributed cache is cleared by a node rejoining

by Steven Hawkins (JIRA)

In a cluster the distributed cache is cleared by a node rejoining ----------------------------------------------------------------- Key: TEIID-1493 URL: https://issues.jboss.org/browse/TEIID-1493 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The load event for a vdb (even startup) will trigger a clearing of the cache, which when clustered will include the distributed entries. In a clustered mode we assume (and should possibly enforce) that vdb versioning must be used to differentiate vdbs so it should be safe to not clear the replicated area. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1463) limit buffering for large results

by Steven Hawkins (JIRA)

limit buffering for large results --------------------------------- Key: TEIID-1463 URL: https://issues.jboss.org/browse/TEIID-1463 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins In a forward only scenario, if a client lags behind the server a buffer will still be built containing much of result. It would be good to limit the buffer size and prempt proactive processing when exceeded. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-946) add support for in/out out return params

by Steven Hawkins (JIRA)

add support for in/out out return params ---------------------------------------- Key: TEIID-946 URL: https://jira.jboss.org/jira/browse/TEIID-946 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 In/out, out, return parameters should be supported in Teiid defined procedures - not just result sets. The logic for handling them would be similar to what exists for managing the update_count variable. The Designer would also need to remove validation restrictions preventing the usage of these parameters. -- 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

13 years, 2 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1329) API to force metadata read

by Mark Addleman (JIRA)

API to force metadata read -------------------------- Key: TEIID-1329 URL: https://jira.jboss.org/browse/TEIID-1329 Project: Teiid Issue Type: Feature Request Components: AdminApi Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor We have a dynamic set of datasources that are accessed through Teiid. Each data source is represented as a different model within the VDB. Some data sources may not be available at the time Teiid executes the translator's getMetadata() method. When our code detects the data source is available, I'd like to poke Teiid to re-read the appropriate translator's metadata. -- 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, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1516) IS_NULLABLE is reported incorrectly for columns

by Steven Hawkins (JIRA)

IS_NULLABLE is reported incorrectly for columns ----------------------------------------------- Key: TEIID-1516 URL: https://issues.jboss.org/browse/TEIID-1516 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 IS_NULLABLE is the reverse of what it should be. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1059) Add a specific translator for Ingres

by Steven Hawkins (JIRA)

Add a specific translator for Ingres ------------------------------------ Key: TEIID-1059 URL: https://jira.jboss.org/jira/browse/TEIID-1059 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.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

13 years, 2 months

3
7
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2011