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

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.

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:

• Cumulative Update 3 for SQL Server 2016 SP1
• Cumulative Update 5 for SQL Server 2016

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.