[teiid-issues] [JBoss JIRA] Commented: (TEIID-82) subqueries are not supported anywhere other than where and select clauses of querycommands
[
https://jira.jboss.org/jira/browse/TEIID-82?page=com.atlassian.jira.plugi...
]
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