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

[Ryan Emerson (JIRA)]

Ryan Emerson created ISPN-7292:
----------------------------------

             Summary: 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-servers-merge-statement/] for more details.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)