[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:comment-tabpanel&focusedCommentId=12745769#comment-12745769 ] 

Mark Addleman edited comment on TEIID-2152 at 1/14/13 4:29 PM:
---------------------------------------------------------------

Is a draft reference guide available?  I'd like to understand how this works without pushdown and KEY support.  

Due to an unfortunate scrolling issue, I missed the major change in QueryRewriter.  I see that it takes keys from the metadata and then forms an IF statement.  I didn't realize that IF was valid outside a procedure.
                
      was (Author: markaddleman):
    Is a draft reference guide available?  I'd like to understand how this works without pushdown and KEY support
                  
> 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
>             Fix For: 8.3
>
>
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira