FIX: An intra-query deadlock occurs in a query containing UNION ALL in batch mode in SQL Server

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

Symptoms


When you try to run a query that contains a UNION ALL clause in batch mode, an intra-query deadlock occurs.

Resolution


This problem is fixed in the following update for SQL Server:

Cumulative Update 12 for SQL Server 2017

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 standard terminology Microsoft uses to describe software updates.