[teiid-issues] [JBoss JIRA] (TEIID-1990) UNION pushdown

Tue Apr 3 17:09:47 EDT 2012

Mark Addleman created TEIID-1990:
------------------------------------

             Summary: UNION pushdown
                 Key: TEIID-1990
                 URL: https://issues.jboss.org/browse/TEIID-1990
             Project: Teiid
          Issue Type: Bug
            Reporter: Mark Addleman
            Assignee: Steven Hawkins

I have SQL of the form
SELECT a FROM (
   SELECT a FROM ds.t1 UNION
   SELECT a FROM ds.t2
) t

The execution factory extends JDBCExecutionFactory and supports everything except row offset.  It appears that the two unioned SELECTs are being executed as separate statements rather than the entire unioned set being pushed down to the datasource.

Attached is plan

--
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