[teiid-issues] [JBoss JIRA] (TEIID-4544) Change Teradata defaults for dependent joins

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4544.
-----------------------------------
    Resolution: Done


Updated to use a max in of 1024 (taken from the hibernate docs) and a max dependent in predicates of 5 (from the associated forum post).  Also added the class name for the hibernate dialect to allow dependent join pushdown.  If this is backported to 8.12.x the reference to the Teradata14Dialect will not be valid and must be removed.

> Change Teradata defaults for dependent joins
> --------------------------------------------
>
>                 Key: TEIID-4544
>                 URL: https://issues.jboss.org/browse/TEIID-4544
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> Teradata does not suggest hard limits on in predicates, but uses the wording:
> "Queries that contain thousands of arguments within an IN or NOT IN clause sometimes fail."
> It has been reported that the defaults of 50 in predicates with 1000 values each will cause such a failure.



--
This message was sent by Atlassian JIRA
(v7.2.2#72004)