--source include/have_sequence.inc

create table t (v vector(1) not null, vector(v));

insert into t select vec_fromtext(concat('[',seq,']')) FROM seq_1_to_100;

select vec_totext(v) from t order by vec_distance_euclidean(v,vec_fromtext('[0]')) desc limit 10;

# Cleanup

drop table t;

select vec_totext(v) from t order by vec_distance_euclidean(v,vec_fromtext('[0]')) desc limit 10;

vec_totext(v)

[1]

[2]

[3]

[4]

[5]

[6]

[7]

[8]

[9]

[10]