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

ID članka: 3211602 - Poslednji pregled: 17.01.2017. - Verzija: 13

Povratne informacije