Does DataGrip support SQL Server 2025 preview tables that have vector columns?

已完成

I am running this query for a table that has a vector data type column and the results pane is showing no results even though the output pane says it retrieved 10 rows? SSMS 21 shows the results.

Is this related to the fact that it's SQL Server 2025 preview?
---

DECLARE @querytext NVARCHAR (3000) ='i want blue products'
DECLARE @search_vector vector(768) =  AI_GENERATE_EMBEDDINGS(@querytext USE MODEL MyOllamaModel);

--COSINE Measures angle between vectors 0 = similar, 1 = opposite

SELECT TOP(10)   *,             vector_distance('cosine', @search_vector, p.embedding) AS distance
FROM embeddings p
ORDER BY distance;

0

This issue might be related to DBE-23860. Do the following steps help you retrieve the query results?

  1. Enable Auto-Sync for your data source (found under the Options tab in data source Properties).
  2. Restart the IDE.
  3. Synchronize the data source.
  4. Open a new Query Console if you continue to experience the issue.
0

It's working now after upgrading to 2025.2.1.

0

请先登录再写评论。