[teiid-issues] [JBoss JIRA] (TEIID-1656) Add pushdown support for grouping expression over a UNION
Paul Nittel (Closed) (JIRA)
jira-events at lists.jboss.org
Thu Jan 5 08:58:10 EST 2012
[ https://issues.jboss.org/browse/TEIID-1656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Nittel closed TEIID-1656.
------------------------------
Assignee: Paul Nittel (was: Steven Hawkins)
Tested and closed with SOA 5.1 CP
> 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: Paul Nittel
> Fix For: 7.4.1, 7.5
>
> Attachments: AfterPatch-CaseAndAggr.txt, BeforePatch-CaseAndAggr.txt
>
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list