A query that accesses data in a columnstore index causes the Database Engine to receive a floating point exception in SQL Server 2016


In SQL Server 2016, a query that accesses data in a columnstore index may consistently return the following exception:
Error: 3628, Severity: 16, State: 1.

The Database Engine received a floating-point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator.


This issue occurs because processing of a columnstore dictionary containing non-string data may execute an invalid floating point operation.


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

About cumulative updates for SQL Server
About cumulative updates for SQL Server


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


Learn about the terminology Microsoft uses to describe software updates.

ID do Artigo: 3171759 - Última Revisão: 25/07/2016 - Revisão: 1

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard