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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3537:
-------------------------------------

             Summary: 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: 8.12


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
(v6.3.15#6346)