0

I have 2 merges updating the same target table at a given instant and the table has 'Serializable' Isolation level.

One of the merge succeeded and updated the records whereas second one was also succeeded but did not update the records. I was expecting the 2nd one to fail with ConcurrentAppend exception because the version id got incremented but it did not.

How to tackle these scenarios?

Gagan
  • 1,775
  • 5
  • 31
  • 59
  • 2
    please provide more data - what is table structure, how it's partitioned, how the merge condition looks like, what are input data, etc. – Alex Ott Oct 24 '22 at 06:46

0 Answers0