FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016

Si applica a: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


When you query for the number of rows of a Columnstore index from the sys.partitions system view in Microsoft SQL Server 2016, incorrect results are returned.

Resolution


Note After installing the update you may have to rebuild the clustered column index to correct any previous wrong base count in sys.sysrowsets partitioning base-table metadata.

This fix is included in the following cumulative updates for SQL Server:

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