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

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

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

About SQL Server 2016 builds

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.
Eigenschappen

Artikel-id: 3211602 - Laatst bijgewerkt: 17 jan. 2017 - Revisie: 13

Feedback