Michał Warecki created TEIID-3227: ------------------------------------- Summary: Add support for sub-expression pushing of must pushdown functions Key: TEIID-3227 URL: https://issues.jboss.org/browse/TEIID-3227 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.9 Reporter: Michał Warecki Assignee: Steven Hawkins Priority: Minor As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. Example: Input query with not supported group by: SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA Output query (processed by teiid): SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' What I think it should looks like: SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.8#6338)