[ https://issues.jboss.org/browse/TEIID-1656?page=com.atlassian.jira.plugin... ] 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) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1656?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1656: ---------------------------------- Fix Version/s: 7.5 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1656?page=com.atlassian.jira.plugin... ] Paul Nittel closed TEIID-1656. ------------------------------ Assignee: Paul Nittel (was: Steven Hawkins) Tested and closed with SOA 5.1 CP -- 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