[ https://issues.jboss.org/browse/TEIID-3937?page=com.atlassian.jira.plugin... ] Don Krapohl updated TEIID-3937: ------------------------------- Description: Pushdown doesn't happen when two columns are multiplied in the THEN portion of a CASE statement. //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 The output type is bigdecimal that may be a factor in the decision to push down as double datatype does work. was: Pushdown doesn't happen when two columns are multiplied in the THEN portion of a CASE statement. //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)