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

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.