FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016

S’applique à : SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Consider the following scenario:
  • In SQL Server 2016, you create a clustered columnstore index on a table.
  • You run a Select query on the table.
  • The execution plan that's generated for the query contains batch mode operators and a nested loop with a correlated parameter>

In this scenario, a deadlock condition occurs.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

     Cumulative Update 2 for SQL Server 2016 SP1

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.