Hi all, I would like to support validate-from-snapshot-id for MERGE, the same way it works for overwrites.
Today an overwrite reads this option and starts OCC conflict validation from the snapshot i choose. Merge ignores the option and always validated from the snapshot it scanned at merge time. To be clear, this is not multi statement transactions. It is single merge. Why : in a read -> transform -> merge pipeline, my decision on what to merge is based on the snapshot i read at the start (S_read). But MERGE only checks for conflicts from its own scan snapshot (S_scan > S_read), so a conflicting commit landing between S_read and S_scan goes undetected. I want to validate from S_read so the merge fails if anything conflicting happened since i read. Please let me know what you think. Thanks Hemanth Boyina
