FIX: Numeric overflow when you run a query that spills more than 65,535 extents to tempdb in SQL Server 2014 or 2012

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


When you run a query that tries to spill more than 65,535 extents to the tempdb database, an numeric overflow occurs. Therefore, an incorrect is returned.

Cause


This issue occurs because you can't read all the extents back after overflow.

Resolution


Cumulative update information

The issue was first fixed in the following cumulative update of SQL Server:

Status


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