FIX: Access violation when you run a nested select query against a columnstore index in SQL Server

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core More

Symptoms


Assume that you use a columnstore index in Microsoft SQL Server 2016. When you run a nested select query against the columnstore index, an access violation might occur. Additionally, an error message that resembles the following is logged in the SQL Server error log file:

 

Resolution


The fix for this problem is included in the following updates:

Cumulative Update 8 for SQL Server 2017

Cumulative Update 1 for SQL Server 2016 Service Pack 2

Cumulative Update 9 for SQL Server 2016 Service Pack 1

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.