[teiid-issues] [JBoss JIRA] (TEIID-2152) MERGE support

[Mark Addleman (JIRA)]

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

Mark Addleman updated TEIID-2152:
---------------------------------

    Description: 
Support for functionality similar to H2's MERGE command:  http://www.h2database.com/html/grammar.html?highlight=merge&search=merge#merge

I don't know if there is a SQL standard for this and I don't care if the command is identical to H2's.  I'm mostly interested in a single command to support somewhat atomic* "if pkey exists then update else insert" operation

* somewhat atomic =  this doesn't have to be entirely atomic but, to the degree the data source supports the equivalent of a MERGE or JTA

    
> MERGE support
> -------------
>
>                 Key: TEIID-2152
>                 URL: https://issues.jboss.org/browse/TEIID-2152
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> Support for functionality similar to H2's MERGE command:  http://www.h2database.com/html/grammar.html?highlight=merge&search=merge#merge
> I don't know if there is a SQL standard for this and I don't care if the command is identical to H2's.  I'm mostly interested in a single command to support somewhat atomic* "if pkey exists then update else insert" operation
> * somewhat atomic =  this doesn't have to be entirely atomic but, to the degree the data source supports the equivalent of a MERGE or JTA

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira