[teiid-issues] [JBoss JIRA] (TEIID-3537) Use array binding for postgresql dependent join
Steven Hawkins (JIRA)
issues at jboss.org
Wed Mar 21 20:02:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins reassigned TEIID-3537:
-------------------------------------
Fix Version/s: Open To Community
(was: 10.x)
Priority: Minor (was: Major)
Assignee: (was: Steven Hawkins)
Moving to low priority community issue as dependent join pushdown logic mostly supersedes this.
> 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
> Priority: Minor
> Fix For: Open To Community
>
>
> 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.5.0#75005)
More information about the teiid-issues
mailing list