[teiid-issues] [JBoss JIRA] (TEIID-4591) support UPDATE SQL JOIN / FROM

[Steven Hawkins (JIRA)]

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

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-statement-with-join-in-sql
> 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)