FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016 and 2017

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you use Cumulative Update 8 for SQL Server 2016 SP2 or SQL Server 2017. When you try to gather information for a query that you are going to run, such as metadata (typesof columns the query returns), types of parameters, or an estimated execution plan, you may notice that an access violation (AV) occurs if the query contains PIVOT or UNPIVOToperators. Examples of gathering such information include butare not limited to the following:
  • Call sys.sp_describe_first_result_set to obtain the types of columns that the query returns.
  • Call sys.sp_describe_undeclared_parameters to obtain the types of parameters.
  • Call SET SHOWPLAN (or using Microsoft SQL Server Management Studio) to obtain an estimated execution plan.
Additionally, a dump file that resembles the following is generated on the local instance:

Msg 596, Level 21, State 1, Line LineNumber
Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line LineNumber
A severe error occurred on the current command. The results, if any, should be discarded.

Status


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

Resolution


This issue is fixed in the following cumulative updates for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

References


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