FIX: CASE expressions containing identical sub-queries may return incorrect results in SQL Server 2017

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

Symptoms


CASE expressions containing identical sub-queries that are executed in SQL Server 2017 may return incorrect results.

Resolution


The fix for this issue is included in the following update for SQL Server:

Cumulative Update 8 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 that Microsoft uses to describe software updates.