Support for WHEN NOT MATCHED BY SOURCE for MERGE statement [CORE2515] #2925
Comments
Modified by: @cincuranetComponent: Engine [ 10000 ] |
Modified by: @cincuranetdescription: WHEN NOT MATCHED BY SOURCE THEN <merge_matched> Specifies that all rows of target_table that do not match the rows returned by <table_source> ON <merge_search_condition>, and that satisfy any additional search condition, are either updated or deleted according to the <merge_matched> clause. => WHEN NOT MATCHED BY SOURCE THEN <merge_matched> Specifies that all rows of target_table that do not match the rows returned by <table_source> ON <merge_search_condition>, and that satisfy any additional search condition, are either updated or deleted according to the <merge_matched> clause. Useful (not only) with DELETE action [CORE2005]. |
|
Commented by: @asfernandes Jiri, It does not look good feature request for me, sorry. MERGE is driven by <source> query, so that extension would defeat the standard command completelly. |
|
Commented by: @cincuranet OK, no problem. Feel free to close the ticket. |
Modified by: Sean Leyne (seanleyne)status: Open [ 1 ] => Resolved [ 5 ] resolution: Won't Fix [ 2 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @cincuranet
WHEN NOT MATCHED BY SOURCE THEN <merge_matched>
Specifies that all rows of target_table that do not match the rows returned by <table_source> ON <merge_search_condition>, and that satisfy any additional search condition, are either updated or deleted according to the <merge_matched> clause.
Useful (not only) with DELETE action [CORE2005].
The text was updated successfully, but these errors were encountered: