Skip to content

Incorrect error about columnstore index on build #713

@dzsquared

Description

@dzsquared
  • SqlPackage or DacFx Version: 170.2, Microsoft.Build.Sql >= 2.0

Steps to Reproduce:

  1. create a new SQL project (Microsoft.Build.Sql v2)
  2. add a table to the project
CREATE TABLE [dbo].[SampleTable] (
    [id] BIGINT IDENTITY (1, 1) NOT NULL,
    [formData] NVARCHAR(MAX) NULL
);
GO

CREATE CLUSTERED COLUMNSTORE INDEX [cci_SampleTable]
ON [dbo].[SampleTable]
WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0)
ON [PRIMARY];
GO
  1. run dotnet build
  2. build error: Build error SQL71666: Columnstore Index on table containing vector column(s) '[dbo].[SampleTable].[formData]' is not supported.

Did this occur in prior versions? If not - which version(s) did it work in? worked in Microsoft.Build.Sql 1.0 and DacFx 162

Occurs in the original SSDT in VS2026 as well as SDK-style projects

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions