[teiid-issues] [JBoss JIRA] (TEIID-2064) Teradata IN pushdown issues

Tue Jun 5 19:12:17 EDT 2012

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

Steven Hawkins resolved TEIID-2064.
-----------------------------------

    Resolution: Done

Modified the TeradataSQLConversionVisitor to only pull non-literal values out of IN predicates.

> Teradata IN pushdown issues
> ---------------------------
>
>                 Key: TEIID-2064
>                 URL: https://issues.jboss.org/browse/TEIID-2064
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.4.1
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.1
>
>
> In predicates for Teradata are always being expanded to AND/ORs of comparison criteria.  This should only be needed if the predicate values contain a non-literal.  Also the logic does not nest the expansion in parens, which can cause the evaluation to be incorrect when the IN was on the left hand side of an AndOr condition. 

--
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