Hi,
I considered the empty source table situation again. I think it is correct to upsert nothing in this case.
Back to the original logic of MERGE command, it is main purpose is to add the supplementary data from the source table into the target table. Thus, an empty source table means no input data is available, so no upsert is needed in target table.
Regards,
Boxuan