[infinispan-issues] [JBoss JIRA] (ISPN-7292) SQL Server Upsert Errors

SQL Server Upsert Errors ------------------------ Key: ISPN-7292 URL: https://issues.jboss.org/browse/ISPN-7292 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 9.0.0.Beta1 Reporter: Ryan Emerson Assignee: Ryan Emerson When utilising upserts with SQL server an SQL exception is thrown due to a `ambiguous column name`. The existing upstert statement also causes concurrency issues as SQL server does not handle MERGE statements atomically. Consequently it is necessary for a table lock to be acquired per merge statement in order to prevent deadlocks from occurring. See [here|https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-ser...] for more details.