[teiid-issues] [JBoss JIRA] (TEIID-3537) Use array binding for postgresql dependent join

Steven Hawkins (JIRA) issues at jboss.org
Tue Dec 6 09:46:02 EST 2016


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

Steven Hawkins updated TEIID-3537:
----------------------------------
    Fix Version/s: 10.0
                   10.0
                       (was: 9.2)


> Use array binding for postgresql dependent join
> -----------------------------------------------
>
>                 Key: TEIID-3537
>                 URL: https://issues.jboss.org/browse/TEIID-3537
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>
> Rather than creating a large sql statement or rely upon a small fixed limit to the number of binding, we can bind array values to perform dependent query comparisons - where id = ANY ?
> This however only seems to work for single values or composites of the same type.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)


More information about the teiid-issues mailing list