Skip to content

Deploy database with vector_search reference gives warning #706

@llali

Description

@llali
  • 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)

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingfixed-pending-releaseFix in upcoming releasesql25Issues specific to SQL25

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions