Important In Azure Synapse Analytics the MERGE command on builds older than 10.0.17829.0 may, under certain conditions, leave the target table in an inconsistent state, with rows placed in the wrong distribution, causing later queries to return wrong results in some cases.