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


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.


The update that fixes this issue is included in Cumulative Update 1 for SQL Server 2016 Service Pack 1.

About SQL Server 2016 builds


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


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

Article ID: 3211602 - Last Review: 17 ጃንዩ 2017 - Revision: 13

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core