MariaDB 11.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

11.8.8-MariaDB-deb13

-- the VECTOR type arrived in the MariaDB 11.7/11.8 line
create table emb (id int, e vector(2));
insert into emb values (1, vec_fromtext('[1,0]')), (2, vec_fromtext('[0,1]'));

Records: 2  Duplicates: 0  Warnings: 0

select id, vec_totext(e) as vec
     , vec_distance_euclidean(e, vec_fromtext('[1,0]')) as distance_from_first
from emb order by id;

id
vec
distance_from_first

1
[1,0]
0

2
[0,1]
1.4142135623730951

-- uuid_v7() is also new in this line
select length(uuid_v7()) as uuid_length;

uuid_length

36