[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 closed TEIID-3227.
---------------------------------


> 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.15#6346)