-
Notifications
You must be signed in to change notification settings - Fork 25
Closed
Labels
bugSomething isn't workingSomething isn't workingfixed-pending-releaseFix in upcoming releaseFix in upcoming releasesql25Issues specific to SQL25Issues specific to SQL25
Milestone
Description
- SqlPackage or DacFx Version:
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):
Steps to Reproduce:
- 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)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingfixed-pending-releaseFix in upcoming releaseFix in upcoming releasesql25Issues specific to SQL25Issues specific to SQL25