[
https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-3227.
-----------------------------------
Resolution: Done
Added more support for pushing expressions more selectively. We'll now include
arguments to aggregate functions and grouping expressions.
This is just an extension of the existing logic and is not yet fully symbolic, that is we
are dealing with whole projections at the point in time they are used in the grouping or
project node. It will take more work to fully factor sub-expressions (more than likely
replacing with an expression symbol).
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
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)