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:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest 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.