3 ms·
> So what is a legitimate use case for MERGE where not knowing if a record is new or existing is not possible prior to the transaction? I think he concentrates
by viraptor 9y ago
> So what is a legitimate use case for MERGE where not knowing if a record is new or existing is not possible prior to the transaction?
I think he concentrates on "possible" where the interesting use case is "convenient". The are many cases where you want to go from at-least-once execution of idempotent tasks to a consistent view of data. In those cases it's irrelevant if the data existed before or not - you're likely doing an upsert with exactly the same data under exactly the same key and care only the resulting log of events.