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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1990.
-----------------------------------

    Fix Version/s: 7.7.1
                   8.0
       Resolution: Done


I left off the backport of the implicit change since it alters quite a few test cases.  But there was a bug with the debug log info which has been corrected and expanded.  I also added a specific log for the limit case from the forum topic - https://community.jboss.org/thread/197974?tstart=0
                
> UNION pushdown
> --------------
>
>                 Key: TEIID-1990
>                 URL: https://issues.jboss.org/browse/TEIID-1990
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1, 8.0
>
>         Attachments: plan.txt, plan.txt
>
>
> 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