Behavior changes when you add uniqueidentifier columns in a clustered Columnstore Index in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Standard

Summary


This article describes an update that makes the following changes to the Columnstore Indexes feature in SQL Server 2016:
  • Improves the ability to add a non uniqueidentifier column in a clustered Columnstore Index by assigning the default value of NEWID() or NEWSEQUENTIALID() expressions to it.
  • Improves the ability to add a uniqueidentifier column in a clustered Columnstore Index by using an expression of NEWSEQUENTIALID() and NEWID().
  • Fixes an issue that when you add a new uniqueidentifier column in a clustered Columnstore Index, and the new column has a NOT NULL or DEFAULT constraint, NULL values are added to the existing rows.

More Information


This update is included in the following cumulative update 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.