[teiid-issues] [JBoss JIRA] (TEIID-2036) Use array comparison for dependent join using multiple attributes.

Fri Aug 10 10:55:06 EDT 2012

     [ https://issues.jboss.org/browse/TEIID-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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