FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012

Platí pro: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard

Symptoms


Assume that you have an indexed view that uses the SUM() function in Microsoft SQL Server 2012. After you perform an insert or delete operation on the base table, the view returns incorrect results.

Resolution


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

Cumulative Update 7 for SQL Server 2012 SP2

Status


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