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

Thu Jun 23 15:40:23 EDT 2011

Add pushdown support for Searched CASE expression over a UNION
--------------------------------------------------------------

                 Key: TEIID-1656
                 URL: https://issues.jboss.org/browse/TEIID-1656
             Project: Teiid
          Issue Type: Enhancement
          Components: Query Engine, Server
    Affects Versions: 7.4, 7.1.1
            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 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.

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