MySQL 9.7

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

select version();

version()

9.7.1

-- the VECTOR type arrived in the MySQL 9 series
create table emb (id int, e vector(3));
insert into emb values (1, string_to_vector('[1,2,3]'))
                     , (2, string_to_vector('[4,5,6]'));

Records: 2  Duplicates: 0  Warnings: 0

select id, vector_dim(e) as dims, vector_to_string(e) as vec
from emb
order by id;

id
dims
vec

1
3
[1.00000e+00,2.00000e+00,3.00000e+00]

2
3
[4.00000e+00,5.00000e+00,6.00000e+00]

-- materialized views are also new in the 9 series
create materialized view total as select sum(id) as s from emb;
select * from total;

s

3

id	dims	vec
1	3	[1.00000e+00,2.00000e+00,3.00000e+00]
2	3	[4.00000e+00,5.00000e+00,6.00000e+00]