[
https://issues.jboss.org/browse/TEIID-2554?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2554:
---------------------------------------
Merge doesn't buy you that much for materialization updates. New rows you can already
process using the existing merge syntax. Unless you are comparing all rows, there is no
graceful way of detecting updates. You'd have to have a notion of an update
timestamp/increment, which you can process efficiently without the merge in any case.
I'd have to give this pretty low priority/leave it unbucketted given the lack of
standardization (although it is part of ansi, just not widely followed) and the amount of
pieces needed to implement it. Also under the covers the current merge handling is
nothing more than a compensating procedure, there's still no notion of pushdown merge
support (somewhat due to the previous statement).
Enhance MERGE to support INSERT/UPDATE and DELETE
-------------------------------------------------
Key: TEIID-2554
URL:
https://issues.jboss.org/browse/TEIID-2554
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 8.4
Reporter: Van Halbert
Assignee: Steven Hawkins
Add delete support to MERGE. Example is SQL Server:
MERGE <target_table> [AS TARGET]
USING <table_source> [AS SOURCE]
ON <search_condition>
[WHEN MATCHED
THEN <merge_matched> ]
[WHEN NOT MATCHED [BY TARGET]
THEN <merge_not_matched> ]
[WHEN NOT MATCHED BY SOURCE
THEN <merge_ matched> ];
--
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