-
Notifications
You must be signed in to change notification settings - Fork 25
Closed
Labels
Milestone
Description
- SqlPackage or DacFx Version: 170.2, Microsoft.Build.Sql >= 2.0
Steps to Reproduce:
- create a new SQL project (Microsoft.Build.Sql v2)
- 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- run dotnet build
- 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
Reactions are currently unavailable