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: Enhancement
Components: Query Engine
Affects Versions: 8.9
Reporter: MichaĆ Warecki
Assignee: Steven Hawkins
Priority: Minor
Fix For: 8.10
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