[
https://issues.jboss.org/browse/TEIID-2152?page=com.atlassian.jira.plugin...
]
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=me...
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