[teiid-issues] [JBoss JIRA] Resolved: (TEIID-536) Evaluate uncorrleated subqueries prior to pushdown for all command types.

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-536.
----------------------------------

    Fix Version/s: 7.1.1
                       (was: 8.x)
       Resolution: Done


Added better detection and evaluation of non-pushdown sub-queries even in update/stored proc scenarios (this was a side effect of TEIID-1322).  It would be possible (although not as likely of a situation) to add handling for exists or to rewrite some of quantified comparisons as scalars.  This will be done if needed.

> Evaluate uncorrleated subqueries prior to pushdown for all command types. 
> --------------------------------------------------------------------------
>
>                 Key: TEIID-536
>                 URL: https://jira.jboss.org/browse/TEIID-536
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.1.1
>
>
> Criteria and expressions containing uncorrelated subqueries that cannot be pushed down should be evaluated at the access node.  Currently they require the introduction of a separate select node or will simply fail for insert/update/delete.
> See also JBEDSP-928

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira