[teiid-issues] [JBoss JIRA] Updated: (TEIID-1656) Add pushdown support for grouping expression over a UNION

Steven Hawkins (JIRA) jira-events at lists.jboss.org
Mon Jun 27 14:55:23 EDT 2011


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

Steven Hawkins updated TEIID-1656:
----------------------------------

        Summary: Add pushdown support for grouping expression over a UNION  (was: Add pushdown support for Searched CASE expression over a UNION)
    Description: 
1) User has created a view MyView containing UNION all of two other views, eg "SELECT * FROM View1 UNION ALL SELECT * FROM View 2".
2) Then a user query containing a searched CASE type expression is submitted against the view, eg "SELECT max(col) FROM MyView group by CASE WHEN StringNum IS NULL THEN 0 ELSE 1 END"
3) With current planner the CASE expression / group by is not pushed down to the individual sources.  The enhancement request is to allow the pushdown.

  was:
1) User has created a view MyView containing UNION all of two other views, eg "SELECT * FROM View1 UNION ALL SELECT * FROM View 2".
2) Then a user query containing a searched CASE type expression is submitted against the view, eg "SELECT CASE WHEN StringNum IS NULL THEN 0 ELSE 1 END FROM MyView"
3) With current planner the CASE expression is not pushed down to the individual sources.  The enhancement request is to allow the pushdown.

    Component/s:     (was: Server)


> Add pushdown support for grouping expression over a UNION
> ---------------------------------------------------------
>
>                 Key: TEIID-1656
>                 URL: https://issues.jboss.org/browse/TEIID-1656
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>    Affects Versions: 7.1.1, 7.4
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>             Fix For: 7.4.1
>
>
> 1) User has created a view MyView containing UNION all of two other views, eg "SELECT * FROM View1 UNION ALL SELECT * FROM View 2".
> 2) Then a user query containing a searched CASE type expression is submitted against the view, eg "SELECT max(col) FROM MyView group by CASE WHEN StringNum IS NULL THEN 0 ELSE 1 END"
> 3) With current planner the CASE expression / group by is not pushed down to the individual sources.  The enhancement request is to allow the pushdown.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


More information about the teiid-issues mailing list