[
https://issues.jboss.org/browse/TEIID-4591?page=com.atlassian.jira.plugin...
]
Steven Hawkins reassigned TEIID-4591:
-------------------------------------
Component/s: Query Engine
Fix Version/s: 10.0
Assignee: (was: Steven Hawkins)
The usage of an upsert may suffice in some cases. Putting into 10.0 for later
consideration.
support UPDATE SQL JOIN / FROM
------------------------------
Key: TEIID-4591
URL:
https://issues.jboss.org/browse/TEIID-4591
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Omar Khan
Fix For: 10.0
Teiid currently supports basic SET = value WHERE = value syntax.
Having the ability to join for an UPDATE would allow to be pulled from various sources
and not value updates at a time.
The link below contains examples of various syntaxes of an UPDATE with a JOIN could be
accomplished.
http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-stateme...
This enhancement request was the result of the discussion here:
https://developer.jboss.org/thread/273066
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)