FIX: Access violation occurs when you run a query in SQL Server 2016

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 Enterprise CoreSQL Server 2016 Enterprise


Assume that you have a table that has a Clustered Columnstore Index in Microsoft SQL Server 2016. You run a query that has a non-distinct aggregate over a string column against this table. For example, you run SELECT COUNT_BIG(MyStringColumn) from MyClusteredColumnstoreTable. In this scenario, an access violation error occurs.


This problem is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 7 for SQL Server 2016

       Cumulative Update 4 for SQL Server 2016 SP1


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.