[teiid-issues] [JBoss JIRA] (TEIID-3937) Multiplying two columns in CASE statement overrides pushdown

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13154157#comment-13154157 ] 

Steven Hawkins commented on TEIID-3937:
---------------------------------------

> We're ouputting as bigdecimal so that may be a factor in the decision to push down as double datatype does work.

Yes the types can matter.  What specific translator are you using?  And what are the types of column1, column2, and column3?

> Multiplying two columns in CASE statement overrides pushdown
> ------------------------------------------------------------
>
>                 Key: TEIID-3937
>                 URL: https://issues.jboss.org/browse/TEIID-3937
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.4
>         Environment: Ubuntu Trusty
>            Reporter: Don Krapohl
>            Assignee: Steven Hawkins
>
> Pushdown doesn't happen when two columns are multiplied in the THEN portion of a CASE statement with bigdecimal data type.
> //this should push down but does not
> CASE WHEN column1  IS NOT NULL 
> THEN column1 * column2
> ELSE column3 END
> //but you can multiply the columns by a constant and it will push down
> CASE WHEN column1  IS NOT NULL 
> THEN column1 * 34567
> ELSE column3 END
> //or
> CASE WHEN column1  IS NOT NULL 
> THEN 34567 * column2
> ELSE column3 END
> We're ouputting as bigdecimal so that may be a factor in the decision to push down as double datatype does work.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)