[teiid-issues] [JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)