[teiid-issues] [JBoss JIRA] (TEIID-1170) Support subqueries in temp table update/delete criteria
Steven Hawkins (JIRA)
issues at jboss.org
Thu Dec 11 14:09:29 EST 2014
[ https://issues.jboss.org/browse/TEIID-1170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-1170.
-----------------------------------
Resolution: Done
Added support for all subqueries as long as the temp table has a primary key.
Temp tables without a primary key will still have an issue with in/correlated subqueries. We could resolve that last deficiency by allowing the compensating procedure use the row id (which is however not currently visible). We'll address that last case when needed.
> Support subqueries in temp table update/delete criteria
> -------------------------------------------------------
>
> Key: TEIID-1170
> URL: https://issues.jboss.org/browse/TEIID-1170
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 6.0.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 8.10
>
>
> Subqueries are currently not supported in temp table update/delete criteria.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
More information about the teiid-issues
mailing list