[teiid-issues] [JBoss JIRA] Resolved: (TEIID-82) subqueries are not supported anywhere other than where and select clauses of querycommands

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-82.
---------------------------------

    Resolution: Done


Addressed with the creation of a SubqueryAwareEvaluator that performs in place evaluation of subqueries following roughly the same rules as the subqueryprocessorutility.  One drawback is that the initial processing plan needs cloned, however preregistration of the plan with the evaluator could eliminate that overhead (the overhead is actually much less now that the language objects are not cloned).

> subqueries are not supported anywhere other than where and select clauses of querycommands
> ------------------------------------------------------------------------------------------
>
>                 Key: TEIID-82
>                 URL: https://jira.jboss.org/jira/browse/TEIID-82
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.x
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 6.1.0
>
>
> Defect Tracker #23760: Subqueries in other place, for example, delete, update, and procedure if statements, and join criteria do not support subqueries in criteria.  If this cannot be worked for 5.6, then validations should be added so that invalid subqueries are detected.

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