Comment
02-05-2025
05:24 AM
02-05-2025
05:24 AM
What happens in DBRS 16.1 if the WHEN condition is this:
WHEN MATCHED AND s.value IS DISTINCT FROM t.value
Basically saying when it matches on the PK but then check if the other columns are different before taking an action like UPDATE.