[
https://issues.jboss.org/browse/TEIID-2036?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2036.
-----------------------------------
Resolution: Done
Added limited support for an array type in the engine and at the translator level to
support multi-attribute dependent join comparisons. In all other ways the logic still
functions as it used to, such as individually binding the parameters (drivers have
inconsistent handling for creating array types - and also have issues with creating mixed
array types). Note that the teiid parser does not recognize an array constructor, this is
currently only an internal concept.
This will also improve the performance of non-pushed dependent joins as the engine will
process the comparisons in array form as well.
Improvements can be added in the future, such as additional translator support (currently
only h2/oracle), full array support (covered by a different jira), better binding (such as
creating driver array values), etc.
Use array comparison for dependent join using multiple attributes.
------------------------------------------------------------------
Key: TEIID-2036
URL:
https://issues.jboss.org/browse/TEIID-2036
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.1
Many jdbc sources support array comparison which is more efficient that expressing
comparisons using a cross space of in predicates.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira