July 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-669) Support "pass though" SQL commands to sources

by Ramesh Reddy (JIRA)

Support "pass though" SQL commands to sources --------------------------------------------- Key: TEIID-669 URL: https://jira.jboss.org/jira/browse/TEIID-669 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 6.2.0 Currently there is no mechanism in Teiid, when a query is submitted to a runtime engine that is passed through the query engine unadulterated and unmodified and submitted directly to a source connector. All queries are parsed, optimized, re-written. Some times this limits the functionality in Teiid, when a user would like to execute a query that is very "source" specific. For example Oracle supports lots of Oracle specific functions that are not supported by the SQL spec, to support execution of these in Teiid user need to resort to UDF, which is cumbersome and involves modelling. Another benefit of this is also to pass DDL to sources, currently since Teiid does not support DDL, this is not possible at all. There is no-expectation that these queries are part of any data integration, these are one off queries that enhance user experience with Teiid if they use this feature. Command Payload mechanism is similar system that is used for authentication and authorization needs at the connector level, this feature can use similar techniques or use some custom extension to the language to define a query etc. -- 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

11 years, 5 months

6
18
0 / 0

[JBoss JIRA] Created: (TEIID-657) Support Batched Updates in the Salesforce Connector

by John Doyle (JIRA)

Support Batched Updates in the Salesforce Connector --------------------------------------------------- Key: TEIID-657 URL: https://jira.jboss.org/jira/browse/TEIID-657 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Affects Versions: 6.0.0, 6.1.0 Reporter: John Doyle Assignee: John Doyle Salesforce supports batched updates via the WS API. Since Teiid supports batched updates as well, the SF connector should support them. -- 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

11 years, 5 months

4
9
0 / 0

[JBoss JIRA] Created: (TEIID-554) searchability metadata should be type based

by Steven Hawkins (JIRA)

searchability metadata should be type based ------------------------------------------- Key: TEIID-554 URL: https://jira.jboss.org/jira/browse/TEIID-554 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x Since searchability metadata is element based our check for (CapabilitiesUtil) gathers all elements in the expression - regardless of the type of the whole expression. This may be quite difficult to make this change in the existing metadata framework. -- 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

12 years, 5 months

2
1
0 / 0

[JBoss JIRA] Created: (TEIID-511) Make process plans serizializable.

by Steven Hawkins (JIRA)

Make process plans serizializable. ---------------------------------- Key: TEIID-511 URL: https://jira.jboss.org/jira/browse/TEIID-511 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.x Processing plans should be serializable to take advantage of replication and non-memory caches. See also TEIID-81 -- 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

12 years, 5 months

2
1
0 / 0

[JBoss JIRA] Created: (TEIID-513) Make the commandcontext available to the evaluatablevisitor

by Steven Hawkins (JIRA)

Make the commandcontext available to the evaluatablevisitor ----------------------------------------------------------- Key: TEIID-513 URL: https://jira.jboss.org/jira/browse/TEIID-513 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.x If the commandcontext is available to the evaluatablevisitor, then we can make a better decision about what determinism level to accept for planning function 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

12 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-417) Add REST Support to Data Services

by Ted Jones (JIRA)

Add REST Support to Data Services --------------------------------- Key: TEIID-417 URL: https://jira.jboss.org/jira/browse/TEIID-417 Project: Teiid Issue Type: Feature Request Components: SOAP Services Reporter: Ted Jones Assignee: Ted Jones Need to add support for REST to data services. REST needs be enabled in Axis2 and a REST endpoint should be added to the data services WSDL. -- 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

12 years, 8 months

4
13
0 / 0

[JBoss JIRA] Created: (TEIID-586) Like pushdown handling

by Steven Hawkins (JIRA)

Like pushdown handling ---------------------- Key: TEIID-586 URL: https://jira.jboss.org/jira/browse/TEIID-586 Project: Teiid Issue Type: Bug Components: LDAP Connector, Query Engine, Salesforce Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 Both salesforce and ldap like semantics are not the same as SQL. We could capture this with more capabilities supportsLikeCaseSensitive and supportsLikeWildcardSingleCharacter repectively, or another approach would be to allow the connector to generically indicate partial support and have the query engine both push down the conjunct and leave a copy to be applied after the query. With either explicit supports or generic partial support it would only applicable to top level where clause conjuncts. -- 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

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-587) Better pushdown support for exotic joins

by Steven Hawkins (JIRA)

Better pushdown support for exotic joins ---------------------------------------- Key: TEIID-587 URL: https://jira.jboss.org/jira/browse/TEIID-587 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.1.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Our optimizations get in the way of Salesforce pushdown. Specifically rewriting like when possible to = and converting outer joins to inner joins. In both cases we would need to not perform the optimization in the first place or convert into an acceptable form prior to pushdown. The next is that salesforce, while requiring key criteria also allows other criteria in the left outer join on clause (which would be the same as having criteria on the nested relationship query in the salesforce query). With the capabilities as currently defined this would cause the query to not be pushed down. We should consider adding a relational supported join criteria type that requires key criteria but allows for outside criteria. Also we should treat the lack of inner join support to mean that criteria on the inner side of an outer join cannot be pushed. -- 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
4
0 / 0

[JBoss JIRA] Created: (TEIID-536) Evaluate uncorrleated subqueries prior to pushdown for all command types.

by Steven Hawkins (JIRA)

Evaluate uncorrleated subqueries prior to pushdown for all command types. -------------------------------------------------------------------------- Key: TEIID-536 URL: https://jira.jboss.org/jira/browse/TEIID-536 Project: Teiid Issue Type: Feature Request Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.x Criteria and expressions containing uncorrelated subqueries that cannot be pushed down should be evaluated at the access node. Currently they require the introduction of a separate select node or will simply fail for insert/update/delete. See also JBEDSP-928 -- 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

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-715) Allow the user to set null ordering behavior

by Steven Hawkins (JIRA)

Allow the user to set null ordering behavior -------------------------------------------- Key: TEIID-715 URL: https://jira.jboss.org/jira/browse/TEIID-715 Project: Teiid Issue Type: Feature Request Components: Connector API, Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3.0 Sources that support order by may have different null ordering behavior than Teiid (which currently treats null as low). We should support the option for the server to be configured as nulls high, low, always high, or always low. Connectors will need to indicate the sort mode they support so the appropriate push-down and compensating actions can be taken. -- 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, 8 months

2
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2009