DacFx icon indicating copy to clipboard operation
DacFx copied to clipboard

Deploy database with vector_search reference gives warning

Open llali opened this issue 6 months ago • 0 comments

  • SqlPackage or DacFx Version:
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Steps to Reproduce:

  1. Create a database with these objects: CREATE TABLE dbo.Articles ( id INT PRIMARY KEY, title NVARCHAR(100), content NVARCHAR(MAX), embedding VECTOR(5) -- mocked embeddings ); GO

CREATE VECTOR INDEX vec_idx ON Articles(embedding) WITH (metric = 'cosine', type = 'diskann'); GO CREATE PROCEDURE dbo.vector_search @qv /parameter name/ vector(5) AS SELECT t.id, t.title, t.content, s.distance FROM VECTOR_SEARCH( table = dbo.Articles AS t, column = embedding, similar_to = @qv, metric = 'cosine', top_n = 3 ) AS s GO 2. Extract to a dacpac Expected: Extract should succeed Actual: Extract succeed with warnings "*** Error validating element [dbo].[vector_search]: The reference to the column embedding could not be resolved." Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

llali avatar Oct 15 '25 16:10 llali