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

Sat Apr 25 08:20:46 EDT 2009

    [ https://jira.jboss.org/jira/browse/TEIID-82?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12464491#action_12464491 ] 

Steven Hawkins commented on TEIID-82:
-------------------------------------

Removed the link to JBEDSP-928.  It's defect line needs to be broken into two paths 
1. Non-corrleated non-set subquery evaluation prior to pushdown for all command types.
2. Row based execution of updates (virtual and even physical), which is needed in situations where the update or delete criteria / update set clause contain expressions that cannot be pushed or handled by our update procedure logic.

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