mssql-docker icon indicating copy to clipboard operation
mssql-docker copied to clipboard

Vector initialization doesn't work

Open yarmoliq opened this issue 7 months ago • 0 comments

Installed slq server 17.0.700.0 in docker on macos

Tried running:

DECLARE @v1 VECTOR(3) = '[1.0, -0.2, 30]';
DECLARE @v2 VECTOR(3) = JSON_ARRAY(1.0, -0.2, 30);

Got this error message (on both and either of the declarations):

[S0001][596] Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded.

This is from docker logs:

2025-06-07 03:00:00 16:55:38.39 Server      Error: 17310, Severity: 20, State: 1.
2025-06-07 19:55:38 
2025-06-07 03:00:00 16:55:38.39 Server      A user request from the session with SPID 76 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

yarmoliq avatar Jun 07 '25 17:06 yarmoliq