You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Verified that one may use MERGE which contains up to 254 WHEN-conditions (with trivial statements like: when NOT matched and http://s.id = 254 then insert values(http://s.id, s.x) or when matched and http://s.id = 254 then update set t.x = t.x + s.x).
Test Details: Verified that one may use MERGE which contains up to 254 WHEN-conditions (with trivial statements like: when NOT matched and http://s.id = 254 then insert values(http://s.id, s.x) or when matched and http://s.id = 254 then update set t.x = t.x + s.x).
Submitted by: @asfernandes
Votes: 2
Combined with WHEN conditions, this makes MERGE very powerful.
Commits: 9f16366 372d48c FirebirdSQL/fbt-repository@a1a4b7b
====== Test Details ======
Verified that one may use MERGE which contains up to 254 WHEN-conditions (with trivial statements like: when NOT matched and http://s.id = 254 then insert values(http://s.id, s.x) or when matched and http://s.id = 254 then update set t.x = t.x + s.x).
::: NB :::
JFYI: Statement MERGE ... RETURNING will fail always if SOURCE contain more than 1 row. Even if MERGE condition doesn not affected more than one record in TARGET.
Discussion (rus): http://sql.ru/forum/actualutils.aspx?action=gotomsg&tid=1159066&msg=17706227
The text was updated successfully, but these errors were encountered: