[ https://issues.jboss.org/browse/TEIID-3937?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3937: --------------------------------------- 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 -- This message was sent by Atlassian JIRA (v6.4.11#64026)