Debian Codegraph @

mysql-test/suite/mariabackup/vector.test

raw
1 create table t1 (id int auto_increment primary key, v vector(5) not null, vector index (v)) engine=innodb;
2 insert t1 (v) values (Vec_Fromtext('[0.418,0.809,0.823,0.598,0.033]')),
3 (Vec_Fromtext('[0.687,0.789,0.496,0.574,0.917]')),
4 (Vec_Fromtext('[0.333,0.962,0.467,0.448,0.475]')),
5 (Vec_Fromtext('[0.822,0.185,0.683,0.211,0.554]')),
6 (Vec_Fromtext('[0.437,0.167,0.077,0.428,0.241]')),
7 (Vec_Fromtext('[0.769,0.926,0.803,0.015,0.589]')),
8 (Vec_Fromtext('[0.493,0.641,0.761,0.942,0.425]')),
9 (Vec_Fromtext('[0.924,0.275,0.054,0.073,0.136]')),
10 (Vec_Fromtext('[0.186,0.696,0.035,0.668,0.847]')),
11 (Vec_Fromtext('[0.415,0.609,0.426,0.988,0.475]'));
12 select id from t1 order by vec_distance_euclidean(v, Vec_FromText('[1,0,0,0,0]')) limit 3;
13
14 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
15 let $backup_log=$MYSQLTEST_VARDIR/tmp/backup.log;
16
17 --disable_result_log
18 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
19 exec $XTRABACKUP --prepare --target-dir=$targetdir;
20 --enable_result_log
21
22 drop table t1;
23 --list_files $targetdir/test
24 --source include/restart_and_restore.inc
25
26 show create table t1;
27 select id, Vec_ToText(v) from t1;
28 select id from t1 order by vec_distance_euclidean(v, Vec_FromText('[1,0,0,0,0]')) limit 3;
29 drop table t1;
30 rmdir $targetdir;
31
32 --echo #
33 --echo # MDEV-35258 Mariabackup does not work with MyISAM tables with vector keys
34 --echo #
35
36 create table t1 (a int, v vector(1) not null, vector(v)) engine=MyISAM;
37 insert into t1 values (1,0x31313131),(2,0x32323232);
38 --disable_result_log
39 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
40 exec $XTRABACKUP --prepare --target-dir=$targetdir;
41 --enable_result_log
42
43 drop table t1;
44 --list_files $targetdir/test
45 --source include/restart_and_restore.inc
46
47 show create table t1;
48 select * from t1 order by vec_distance_euclidean(v, 0x30303030) limit 1;
49 drop table t1;
50 rmdir $targetdir;