]
Ryan Emerson updated ISPN-7292:
-------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request:
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.