Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 11.7.0-MariaDB-debug-log Source distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [test]> create or replace table t (a int, v vector(2), primary key(v), unique vector(v)) engine=MyISAM; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'vector(v)) engine=MyISAM' at line 1 MariaDB [test]> create or replace table t (a int, v vector(2), primary key(v), vector unique(v)) engine=MyISAM; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'unique(v)) engine=MyISAM' at line 1 MariaDB [test]> create or replace table t (a int, v vector(2), primary key(v), vector(v), unique(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show create table t; +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t | CREATE TABLE `t` ( `a` int(11) DEFAULT NULL, `v` vector(2) NOT NULL, PRIMARY KEY (`v`), UNIQUE KEY `v_2` (`v`), VECTOR KEY `v` (`v`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [test]> show index in t; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | t | 0 | PRIMARY | 1 | v | A | 0 | NULL | NULL | | BTREE | | | NO | | t | 0 | v_2 | 1 | v | A | 0 | NULL | NULL | | BTREE | | | NO | | t | 1 | v | 1 | v | A | NULL | NULL | NULL | | VECTOR | | | NO | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 3 rows in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(2) invisible, vector (v)) engine=MyISAM; ERROR 1252 (42000): All parts of a VECTOR index must be NOT NULL MariaDB [test]> create or replace table t (a int, v vector(2) not null invisible, vector (v)) engine=MyISAM; ERROR 4108 (HY000): Invisible column `v` must have a default value MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible, vector (v)) engine=MyISAM; Query OK, 0 rows affected (0.023 sec) MariaDB [test]> show index in t; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | t | 1 | v | 1 | v | A | NULL | NULL | NULL | | VECTOR | | | NO | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible, vector(v), index(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show index in t; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | t | 1 | v_2 | 1 | v | A | NULL | NULL | NULL | | BTREE | | | NO | | t | 1 | v | 1 | v | A | NULL | NULL | NULL | | VECTOR | | | NO | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 2 rows in set (0.002 sec) MariaDB [test]> show columns in t; +-------+-----------+------+-----+---------+-----------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+-----+---------+-----------+ | a | int(11) | YES | | NULL | | | v | vector(1) | NO | MUL | 0000 | INVISIBLE | +-------+-----------+------+-----+---------+-----------+ 2 rows in set (0.002 sec) MariaDB [test]> desc t; +-------+-----------+------+-----+---------+-----------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+-----+---------+-----------+ | a | int(11) | YES | | NULL | | | v | vector(1) | NO | MUL | 0000 | INVISIBLE | +-------+-----------+------+-----+---------+-----------+ 2 rows in set (0.002 sec) MariaDB [test]> show table status t; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 't' at line 1 MariaDB [test]> show table status as 'tä; '> '; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as 'tä; '' at line 1 MariaDB [test]> show table status as 't'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as 't'' at line 1 MariaDB [test]> show table status like 't'; +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------------+----------+----------------+---------+--------------------+-----------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary | +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------------+----------+----------------+---------+--------------------+-----------+ | t | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-24 00:48:30 | 2024-10-24 00:48:30 | NULL | utf8mb4_uca1400_ai_ci | NULL | | | 288230376151710720 | N | +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------------+----------+----------------+---------+--------------------+-----------+ 1 row in set (0.002 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:48:30 Update_time: 2024-10-24 00:48:30 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 288230376151710720 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible) engine=MyISAM; Query OK, 0 rows affected (0.039 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:50:10 Update_time: 2024-10-24 00:50:10 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030) engine=MyISAM; Query OK, 0 rows affected (0.036 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:50:34 Update_time: 2024-10-24 00:50:34 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v blob not null default 0x30303030) engine=MyISAM; Query OK, 0 rows affected (0.036 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 11 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:50:48 Update_time: 2024-10-24 00:50:48 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030) engine=MyISAM; Query OK, 0 rows affected (0.036 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:50:57 Update_time: 2024-10-24 00:50:57 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(2) not null default 0x30303030) engine=MyISAM; ERROR 1067 (42000): Invalid default value for 'v' MariaDB [test]> create or replace table t (a int, v vector(2) not null) engine=MyISAM; Query OK, 0 rows affected (0.023 sec) MariaDB [test]> create or replace table t (a int, v vector(2) not null default 0x30303030) engine=MyISAM; ERROR 1067 (42000): Invalid default value for 'v' MariaDB [test]> create or replace table t (a int, v vector(2) not null) engine=MyISAM; Query OK, 0 rows affected (0.022 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:51:15 Update_time: 2024-10-24 00:51:15 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(2) not null invisible) engine=MyISAM; ERROR 4108 (HY000): Invisible column `v` must have a default value MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030) engine=MyISAM; Query OK, 0 rows affected (0.022 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:51:42 Update_time: 2024-10-24 00:51:42 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible) engine=MyISAM; Query OK, 0 rows affected (0.037 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:51:49 Update_time: 2024-10-24 00:51:49 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030, vector(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:00 Update_time: 2024-10-24 00:52:00 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 17179868160 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible, vector(v), index(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:20 Update_time: 2024-10-24 00:52:20 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 288230376151710720 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 invisible, index(v)) engine=MyISAM; Query OK, 0 rows affected (0.037 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:25 Update_time: 2024-10-24 00:52:25 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 288230376151710720 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030, index(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:34 Update_time: 2024-10-24 00:52:34 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 288230376151710720 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v binary(1), index(v)) engine=MyISAM; Query OK, 0 rows affected (0.038 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Fixed Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 1970324836974591 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:45 Update_time: 2024-10-24 00:52:45 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 1125899906841600 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v binary(8), index(v)) engine=MyISAM; Query OK, 0 rows affected (0.028 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Fixed Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 3659174697238527 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:52:51 Update_time: 2024-10-24 00:52:51 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 1125899906841600 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v blob, index(v)) engine=MyISAM; Query OK, 0 rows affected, 1 warning (0.030 sec) MariaDB [test]> show warnings; +-------+------+----------------------------------------------------------+ | Level | Code | Message | +-------+------+----------------------------------------------------------+ | Note | 1071 | Specified key was too long; max key length is 1000 bytes | +-------+------+----------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 4096 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:53:00 Update_time: 2024-10-24 00:53:00 Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 18446744073709551615 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030, vector(v)) engine=InnoDB; Query OK, 0 rows affected (0.067 sec) MariaDB [test]> show table status like 't' \G *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2024-10-24 00:53:28 Update_time: NULL Check_time: NULL Collation: utf8mb4_uca1400_ai_ci Checksum: NULL Create_options: Comment: Max_index_length: 0 Temporary: N 1 row in set (0.002 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030, vector(v)) engine=InnoDB with system versioning; Query OK, 0 rows affected (0.083 sec) MariaDB [test]> insert into t (a) values (1),(2),(3); Query OK, 3 rows affected (0.021 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [test]> delete from t where a != 1; Query OK, 2 rows affected (0.025 sec) MariaDB [test]> select * from t order by vec_distance_euclidean(v,0x31313131) limit 2; +------+------+ | a | v | +------+------+ | 1 | 0000 | +------+------+ 1 row in set (0.003 sec) MariaDB [test]> select * from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 2; +------+------+ | a | v | +------+------+ | 2 | 0000 | | 1 | 0000 | +------+------+ 2 rows in set (0.001 sec) MariaDB [test]> select * from t for system_time now() order by vec_distance_euclidean(v,0x31313131) limit 2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'now() order by vec_distance_euclidean(v,0x31313131) limit 2' at line 1 MariaDB [test]> select * from t for system_time as of now() order by vec_distance_euclidean(v,0x31313131) limit 2; +------+------+ | a | v | +------+------+ | 1 | 0000 | +------+------+ 1 row in set (0.002 sec) MariaDB [test]> explain select * from t for system_time now() order by vec_distance_euclidean(v,0x31313131) limit 2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'now() order by vec_distance_euclidean(v,0x31313131) limit 2' at line 1 MariaDB [test]> explain select * from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 2; +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 2 | | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ 1 row in set (0.001 sec) MariaDB [test]> explain select * from t order by vec_distance_euclidean(v,0x31313131) limit 2; +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 2 | Using where | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ 1 row in set (0.001 sec) MariaDB [test]> insert into t SELECT s2.seq, VEC_FROMTEXT(concat('[', GROUP_CONCAT(FORMAT(-1 + 2*RAND(),3)), ']')) FROM seq_1_to_1 s1, seq_1_to_100 s2 GROUP BY s2.seq; Query OK, 100 rows affected (0.329 sec) Records: 100 Duplicates: 0 Warnings: 0 MariaDB [test]> explain select * from t order by vec_distance_euclidean(v,0x31313131) limit 10; +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 10 | Using where | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ 1 row in set (0.001 sec) MariaDB [test]> explain select * from t order by vec_distance_euclidean(v,0x31313131) limit 50; +------+-------------+-------+------+---------------+------+---------+------+------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+-----------------------------+ | 1 | SIMPLE | t | ALL | NULL | NULL | NULL | NULL | 103 | Using where; Using filesort | +------+-------------+-------+------+---------------+------+---------+------+------+-----------------------------+ 1 row in set (0.001 sec) MariaDB [test]> explain select * from t order by vec_distance_euclidean(v,0x31313131) limit 20; +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 20 | Using where | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ 1 row in set (0.001 sec) MariaDB [test]> select * from t order by vec_distance_euclidean(v,0x31313131) limit 20; +------+------+ | a | v | +------+------+ | 1 | 0000 | | 67 | o� | | 96 | �t� | | 16 | B`e� | | 93 | j�< | | 80 | ���< | | 15 | B`� | | 35 | �t= | | 28 | B`e= | | 26 | ��q= | | 13 | ��u� | | 40 | -�� | | 18 | ���= | | 81 | '� | � |9 | �O | 42 | /�$> | | 50 | T�%� | | 85 | +� | | 84 | ;�O� | | 24 | �(\� | +------+------+ 20 rows in set (0.012 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 20; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [6.40969e-10] | | 67 | [-0.008] | | 96 | [-0.009] | | 16 | [-0.014] | | 93 | [0.023] | | 80 | [0.024] | | 15 | [-0.028] | | 35 | [0.036] | | 28 | [0.056] | | 26 | [0.059] | | 13 | [-0.06] | | 40 | [-0.087] | | 18 | [0.104] | | 81 | [-0.133] | | 39 | [-0.138] | | 42 | [0.161] | | 50 | [-0.162] | | 85 | [-0.167] | | 84 | [-0.203] | | 24 | [-0.215] | +------+---------------+ 20 rows in set (0.003 sec) MariaDB [test]> delete from t where a > 20; Query OK, 80 rows affected (0.361 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 20; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [6.40969e-10] | | 16 | [-0.014] | | 15 | [-0.028] | | 13 | [-0.06] | | 18 | [0.104] | | 9 | [0.239] | | 8 | [-0.27] | | 6 | [-0.349] | | 19 | [0.482] | | 12 | [0.58] | | 4 | [-0.596] | | 5 | [-0.628] | | 2 | [0.669] | | 11 | [-0.679] | | 1 | [-0.846] | | 7 | [-0.864] | | 3 | [0.882] | | 20 | [-0.899] | | 14 | [0.958] | | 17 | [-0.988] | +------+---------------+ 20 rows in set (0.017 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [6.40969e-10] | | 16 | [-0.014] | | 15 | [-0.028] | | 13 | [-0.06] | | 18 | [0.104] | | 9 | [0.239] | | 8 | [-0.27] | | 6 | [-0.349] | | 19 | [0.482] | | 12 | [0.58] | | 4 | [-0.596] | | 5 | [-0.628] | | 2 | [0.669] | | 11 | [-0.679] | | 1 | [-0.846] | | 7 | [-0.864] | | 3 | [0.882] | | 20 | [-0.899] | | 14 | [0.958] | | 17 | [-0.988] | | 10 | [-0.992] | +------+---------------+ 21 rows in set (0.005 sec) MariaDB [test]> explain select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 30 | Using where | +------+-------------+-------+-------+---------------+------+---------+------+------+-------------+ 1 row in set (0.001 sec) MariaDB [test]> explain select a, vec_totext(v) from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 30; +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 30 | | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ 1 row in set (0.001 sec) MariaDB [test]> alter table t add primary key(a,v); ERROR 4119 (HY000): Not allowed for system-versioned `test`.`t`. Change @@system_versioning_alter_history to proceed with ALTER. MariaDB [test]> set statement system_versioning_alter_history=KEEP for alter table t add primary key(a,v); Query OK, 103 rows affected (0.374 sec) Records: 103 Duplicates: 0 Warnings: 0 MariaDB [test]> explain select a, vec_totext(v) from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 30; +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ | 1 | SIMPLE | t | index | NULL | v | 6 | NULL | 30 | | +------+-------------+-------+-------+---------------+------+---------+------+------+-------+ 1 row in set (0.020 sec) MariaDB [test]> select a, vec_totext(v) from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 30; +----+---------------+ | a | vec_totext(v) | +----+---------------+ | 1 | [6.40969e-10] | | 3 | [6.40969e-10] | | 2 | [6.40969e-10] | | 67 | [-0.008] | | 96 | [-0.009] | | 16 | [-0.014] | | 93 | [0.023] | | 80 | [0.024] | | 15 | [-0.028] | | 35 | [0.036] | | 28 | [0.056] | | 26 | [0.059] | | 13 | [-0.06] | | 40 | [-0.087] | | 18 | [0.104] | | 81 | [-0.133] | | 39 | [-0.138] | | 42 | [0.161] | | 50 | [-0.162] | | 85 | [-0.167] | | 84 | [-0.203] | | 24 | [-0.215] | | 9 | [0.239] | | 27 | [0.247] | | 77 | [-0.252] | | 82 | [0.264] | | 8 | [-0.27] | | 97 | [0.298] | | 72 | [-0.299] | | 33 | [-0.3] | +----+---------------+ 30 rows in set (0.029 sec) MariaDB [test]> select a, vec_totext(v) from t for order by vec_distance_euclidean(v,0x31313131) limit 30; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by vec_distance_euclidean(v,0x31313131) limit 30' at line 1 MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +----+---------------+ | a | vec_totext(v) | +----+---------------+ | 1 | [6.40969e-10] | | 16 | [-0.014] | | 15 | [-0.028] | | 13 | [-0.06] | | 18 | [0.104] | | 9 | [0.239] | | 8 | [-0.27] | | 6 | [-0.349] | | 19 | [0.482] | | 12 | [0.58] | | 4 | [-0.596] | | 5 | [-0.628] | | 2 | [0.669] | | 11 | [-0.679] | | 1 | [-0.846] | | 7 | [-0.864] | | 3 | [0.882] | | 20 | [-0.899] | | 14 | [0.958] | | 17 | [-0.988] | | 10 | [-0.992] | +----+---------------+ 21 rows in set (0.017 sec) MariaDB [test]> create or replace table t (a int, v vector(1) not null default 0x30303030 without system versioning, vector(v)) engine=InnoDB with system versioning; Query OK, 0 rows affected (0.096 sec) MariaDB [test]> insert into t SELECT s2.seq, VEC_FROMTEXT(concat('[', GROUP_CONCAT(FORMAT(-1 + 2*RAND(),3)), ']')) FROM seq_1_to_1 s1, seq_1_to_100 s2 GROUP BY s2.seq; Query OK, 100 rows affected (0.287 sec) Records: 100 Duplicates: 0 Warnings: 0 MariaDB [test]> delete from t where a > 20; Query OK, 80 rows affected (0.303 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 18 | [-0.043] | | 5 | [-0.077] | | 7 | [0.096] | | 12 | [-0.131] | | 3 | [0.16] | | 1 | [0.236] | | 8 | [-0.239] | | 17 | [-0.248] | | 2 | [0.373] | | 19 | [-0.475] | | 9 | [-0.483] | | 13 | [-0.52] | | 15 | [0.53] | | 6 | [0.573] | | 4 | [0.681] | | 10 | [-0.699] | | 16 | [-0.731] | | 20 | [0.758] | | 14 | [0.794] | | 11 | [0.954] | +------+---------------+ 20 rows in set (0.016 sec) MariaDB [test]> select a, vec_totext(v) from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 82 | [0.007] | | 66 | [0.012] | | 18 | [-0.043] | | 49 | [-0.05] | | 74 | [0.068] | | 50 | [-0.071] | | 5 | [-0.077] | | 24 | [0.085] | | 7 | [0.096] | | 31 | [-0.111] | | 12 | [-0.131] | | 97 | [-0.136] | | 95 | [-0.155] | | 34 | [0.158] | | 3 | [0.16] | | 36 | [0.163] | | 46 | [0.178] | | 65 | [0.185] | | 99 | [-0.187] | | 32 | [0.204] | | 21 | [0.211] | | 22 | [-0.216] | | 63 | [-0.22] | | 86 | [-0.228] | | 1 | [0.236] | | 8 | [-0.239] | | 54 | [0.24] | | 17 | [-0.248] | | 92 | [0.264] | | 57 | [-0.283] | +------+---------------+ 30 rows in set (0.003 sec) MariaDB [test]> select a, vec_totext(v), row_start, row_end for system_time all; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'system_time all' at line 1 MariaDB [test]> select a, vec_totext(v), row_start, row_end from t for system_time all; +------+---------------+----------------------------+----------------------------+ | a | vec_totext(v) | row_start | row_end | +------+---------------+----------------------------+----------------------------+ | 1 | [0.236] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 2 | [0.373] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 3 | [0.16] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 4 | [0.681] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 5 | [-0.077] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 6 | [0.573] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 7 | [0.096] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 8 | [-0.239] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 9 | [-0.483] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 10 | [-0.699] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 11 | [0.954] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 12 | [-0.131] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 13 | [-0.52] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 14 | [0.794] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 15 | [0.53] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 16 | [-0.731] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 17 | [-0.248] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 18 | [-0.043] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 19 | [-0.475] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 20 | [0.758] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 21 | [0.211] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 22 | [-0.216] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 23 | [-0.712] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 24 | [0.085] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 25 | [-0.438] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 26 | [0.555] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 27 | [-0.912] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 28 | [0.776] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 29 | [-0.385] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 30 | [0.747] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 31 | [-0.111] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 32 | [0.204] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 33 | [0.354] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 34 | [0.158] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 35 | [0.727] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 36 | [0.163] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 37 | [-0.366] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 38 | [0.678] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 39 | [-0.509] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 40 | [0.418] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 41 | [0.619] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 42 | [0.84] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 43 | [-0.657] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 44 | [-0.803] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 45 | [0.954] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 46 | [0.178] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 47 | [-0.972] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 48 | [-0.393] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 49 | [-0.05] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 50 | [-0.071] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 51 | [0.795] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 52 | [-0.81] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 53 | [0.562] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 54 | [0.24] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 55 | [0.514] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 56 | [0.852] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 57 | [-0.283] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 58 | [-0.97] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 59 | [0.998] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 60 | [0.902] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 61 | [0.514] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 62 | [0.864] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 63 | [-0.22] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 64 | [-0.695] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 65 | [0.185] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 66 | [0.012] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 67 | [0.506] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 68 | [-0.508] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 69 | [0.941] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 70 | [-0.769] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 71 | [0.329] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 72 | [0.955] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 73 | [0.787] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 74 | [0.068] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 75 | [0.982] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 76 | [-0.293] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 77 | [0.586] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 78 | [0.812] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 79 | [-0.699] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 80 | [-0.931] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 81 | [0.443] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 82 | [0.007] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 83 | [-0.292] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 84 | [-0.482] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 85 | [-0.535] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 86 | [-0.228] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 87 | [-0.534] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 88 | [-0.985] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 89 | [-0.324] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 90 | [0.337] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 91 | [-0.345] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 92 | [0.264] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 93 | [-0.645] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 94 | [0.982] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 95 | [-0.155] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 96 | [-0.72] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 97 | [-0.136] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 98 | [0.481] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 99 | [-0.187] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 100 | [0.623] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | +------+---------------+----------------------------+----------------------------+ 100 rows in set (0.005 sec) MariaDB [test]> show create table t; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t | CREATE TABLE `t` ( `a` int(11) DEFAULT NULL, `v` vector(1) NOT NULL DEFAULT '0000' WITHOUT SYSTEM VERSIONING, VECTOR KEY `v` (`v`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [test]> create table t2 (a int, b int without system versioning) with system versioning; ERROR 1050 (42S01): Table 't2' already exists MariaDB [test]> create or replace table t2 (a int, b int without system versioning) with system versioning; Query OK, 0 rows affected (0.049 sec) MariaDB [test]> insert into t2 select seq, seq from seq_1_to_100; Query OK, 100 rows affected (0.030 sec) Records: 100 Duplicates: 0 Warnings: 0 MariaDB [test]> delete from t2 where a > 20; Query OK, 80 rows affected (0.042 sec) MariaDB [test]> select a, b, row_start, row_end from t for system_time all; ERROR 1054 (42S22): Unknown column 'b' in 'field list' MariaDB [test]> select a, b, row_start, row_end from t2 for system_time all; +------+------+----------------------------+----------------------------+ | a | b | row_start | row_end | +------+------+----------------------------+----------------------------+ | 1 | 1 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 2 | 2 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 3 | 3 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 4 | 4 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 5 | 5 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 6 | 6 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 7 | 7 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 8 | 8 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 9 | 9 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 10 | 10 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 11 | 11 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 12 | 12 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 13 | 13 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 14 | 14 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 15 | 15 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 16 | 16 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 17 | 17 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 18 | 18 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 19 | 19 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 20 | 20 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 21 | 21 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 22 | 22 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 23 | 23 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 24 | 24 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 25 | 25 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 26 | 26 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 27 | 27 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 28 | 28 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 29 | 29 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 30 | 30 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 31 | 31 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 32 | 32 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 33 | 33 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 34 | 34 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 35 | 35 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 36 | 36 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 37 | 37 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 38 | 38 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 39 | 39 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 40 | 40 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 41 | 41 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 42 | 42 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 43 | 43 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 44 | 44 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 45 | 45 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 46 | 46 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 47 | 47 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 48 | 48 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 49 | 49 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 50 | 50 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 51 | 51 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 52 | 52 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 53 | 53 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 54 | 54 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 55 | 55 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 56 | 56 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 57 | 57 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 58 | 58 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 59 | 59 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 60 | 60 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 61 | 61 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 62 | 62 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 63 | 63 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 64 | 64 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 65 | 65 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 66 | 66 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 67 | 67 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 68 | 68 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 69 | 69 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 70 | 70 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 71 | 71 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 72 | 72 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 73 | 73 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 74 | 74 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 75 | 75 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 76 | 76 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 77 | 77 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 78 | 78 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 79 | 79 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 80 | 80 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 81 | 81 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 82 | 82 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 83 | 83 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 84 | 84 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 85 | 85 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 86 | 86 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 87 | 87 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 88 | 88 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 89 | 89 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 90 | 90 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 91 | 91 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 92 | 92 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 93 | 93 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 94 | 94 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 95 | 95 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 96 | 96 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 97 | 97 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 98 | 98 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 99 | 99 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 100 | 100 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | +------+------+----------------------------+----------------------------+ 100 rows in set (0.005 sec) MariaDB [test]> update t set b = b*10; ERROR 1054 (42S22): Unknown column 'b' in 'field list' MariaDB [test]> update t2 set b = b*10; Query OK, 20 rows affected (0.023 sec) Rows matched: 20 Changed: 20 Inserted: 0 Warnings: 0 MariaDB [test]> select a, b, row_start, row_end from t2 for system_time all; +------+------+----------------------------+----------------------------+ | a | b | row_start | row_end | +------+------+----------------------------+----------------------------+ | 1 | 10 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 2 | 20 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 3 | 30 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 4 | 40 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 5 | 50 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 6 | 60 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 7 | 70 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 8 | 80 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 9 | 90 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 10 | 100 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 11 | 110 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 12 | 120 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 13 | 130 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 14 | 140 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 15 | 150 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 16 | 160 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 17 | 170 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 18 | 180 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 19 | 190 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 20 | 200 | 2024-10-24 01:12:29.813151 | 2106-02-07 08:28:15.999999 | | 21 | 21 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 22 | 22 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 23 | 23 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 24 | 24 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 25 | 25 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 26 | 26 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 27 | 27 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 28 | 28 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 29 | 29 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 30 | 30 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 31 | 31 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 32 | 32 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 33 | 33 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 34 | 34 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 35 | 35 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 36 | 36 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 37 | 37 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 38 | 38 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 39 | 39 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 40 | 40 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 41 | 41 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 42 | 42 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 43 | 43 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 44 | 44 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 45 | 45 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 46 | 46 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 47 | 47 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 48 | 48 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 49 | 49 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 50 | 50 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 51 | 51 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 52 | 52 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 53 | 53 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 54 | 54 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 55 | 55 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 56 | 56 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 57 | 57 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 58 | 58 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 59 | 59 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 60 | 60 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 61 | 61 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 62 | 62 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 63 | 63 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 64 | 64 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 65 | 65 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 66 | 66 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 67 | 67 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 68 | 68 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 69 | 69 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 70 | 70 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 71 | 71 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 72 | 72 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 73 | 73 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 74 | 74 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 75 | 75 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 76 | 76 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 77 | 77 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 78 | 78 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 79 | 79 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 80 | 80 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 81 | 81 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 82 | 82 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 83 | 83 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 84 | 84 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 85 | 85 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 86 | 86 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 87 | 87 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 88 | 88 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 89 | 89 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 90 | 90 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 91 | 91 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 92 | 92 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 93 | 93 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 94 | 94 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 95 | 95 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 96 | 96 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 97 | 97 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 98 | 98 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 99 | 99 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | | 100 | 100 | 2024-10-24 01:12:29.813151 | 2024-10-24 01:12:36.245686 | +------+------+----------------------------+----------------------------+ 100 rows in set (0.005 sec) MariaDB [test]> update t set v = 0x31313131; Query OK, 20 rows affected (0.126 sec) Rows matched: 20 Changed: 20 Inserted: 0 Warnings: 0 MariaDB [test]> select a, vec_totext(v), row_start, row_end from t for system_time all; +------+---------------+----------------------------+----------------------------+ | a | vec_totext(v) | row_start | row_end | +------+---------------+----------------------------+----------------------------+ | 1 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 2 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 3 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 4 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 5 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 6 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 7 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 8 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 9 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 10 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 11 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 12 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 13 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 14 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 15 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 16 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 17 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 18 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 19 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 20 | [2.57849e-9] | 2024-10-24 01:10:39.547282 | 2106-02-07 08:28:15.999999 | | 21 | [0.211] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 22 | [-0.216] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 23 | [-0.712] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 24 | [0.085] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 25 | [-0.438] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 26 | [0.555] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 27 | [-0.912] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 28 | [0.776] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 29 | [-0.385] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 30 | [0.747] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 31 | [-0.111] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 32 | [0.204] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 33 | [0.354] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 34 | [0.158] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 35 | [0.727] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 36 | [0.163] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 37 | [-0.366] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 38 | [0.678] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 39 | [-0.509] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 40 | [0.418] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 41 | [0.619] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 42 | [0.84] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 43 | [-0.657] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 44 | [-0.803] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 45 | [0.954] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 46 | [0.178] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 47 | [-0.972] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 48 | [-0.393] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 49 | [-0.05] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 50 | [-0.071] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 51 | [0.795] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 52 | [-0.81] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 53 | [0.562] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 54 | [0.24] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 55 | [0.514] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 56 | [0.852] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 57 | [-0.283] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 58 | [-0.97] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 59 | [0.998] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 60 | [0.902] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 61 | [0.514] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 62 | [0.864] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 63 | [-0.22] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 64 | [-0.695] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 65 | [0.185] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 66 | [0.012] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 67 | [0.506] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 68 | [-0.508] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 69 | [0.941] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 70 | [-0.769] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 71 | [0.329] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 72 | [0.955] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 73 | [0.787] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 74 | [0.068] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 75 | [0.982] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 76 | [-0.293] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 77 | [0.586] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 78 | [0.812] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 79 | [-0.699] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 80 | [-0.931] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 81 | [0.443] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 82 | [0.007] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 83 | [-0.292] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 84 | [-0.482] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 85 | [-0.535] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 86 | [-0.228] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 87 | [-0.534] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 88 | [-0.985] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 89 | [-0.324] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 90 | [0.337] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 91 | [-0.345] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 92 | [0.264] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 93 | [-0.645] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 94 | [0.982] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 95 | [-0.155] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 96 | [-0.72] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 97 | [-0.136] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 98 | [0.481] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 99 | [-0.187] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | | 100 | [0.623] | 2024-10-24 01:10:39.547282 | 2024-10-24 01:10:53.619710 | +------+---------------+----------------------------+----------------------------+ 100 rows in set (0.003 sec) MariaDB [test]> select a, vec_totext(v) from t for system_time all order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [2.57849e-9] | | 20 | [2.57849e-9] | | 11 | [2.57849e-9] | | 6 | [2.57849e-9] | | 7 | [2.57849e-9] | | 3 | [2.57849e-9] | | 5 | [2.57849e-9] | | 8 | [2.57849e-9] | | 9 | [2.57849e-9] | | 2 | [2.57849e-9] | | 4 | [2.57849e-9] | | 12 | [2.57849e-9] | | 19 | [2.57849e-9] | | 18 | [2.57849e-9] | | 17 | [2.57849e-9] | | 15 | [2.57849e-9] | | 14 | [2.57849e-9] | | 13 | [2.57849e-9] | | 10 | [2.57849e-9] | +------+---------------+ 19 rows in set (0.005 sec) MariaDB [test]> select count(*) from t; +----------+ | count(*) | +----------+ | 20 | +----------+ 1 row in set (0.003 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [2.57849e-9] | | 20 | [2.57849e-9] | | 11 | [2.57849e-9] | | 6 | [2.57849e-9] | | 7 | [2.57849e-9] | | 3 | [2.57849e-9] | | 5 | [2.57849e-9] | | 8 | [2.57849e-9] | | 9 | [2.57849e-9] | | 2 | [2.57849e-9] | | 4 | [2.57849e-9] | | 12 | [2.57849e-9] | | 19 | [2.57849e-9] | | 18 | [2.57849e-9] | | 17 | [2.57849e-9] | | 15 | [2.57849e-9] | | 14 | [2.57849e-9] | | 13 | [2.57849e-9] | | 10 | [2.57849e-9] | +------+---------------+ 19 rows in set (0.003 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) ; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [2.57849e-9] | | 12 | [2.57849e-9] | | 13 | [2.57849e-9] | | 14 | [2.57849e-9] | | 15 | [2.57849e-9] | | 16 | [2.57849e-9] | | 17 | [2.57849e-9] | | 18 | [2.57849e-9] | | 19 | [2.57849e-9] | | 11 | [2.57849e-9] | | 10 | [2.57849e-9] | | 2 | [2.57849e-9] | | 3 | [2.57849e-9] | | 4 | [2.57849e-9] | | 5 | [2.57849e-9] | | 6 | [2.57849e-9] | | 7 | [2.57849e-9] | | 8 | [2.57849e-9] | | 9 | [2.57849e-9] | | 20 | [2.57849e-9] | +------+---------------+ 20 rows in set (0.004 sec) MariaDB [test]> select a, vec_totext(v) from t order by vec_distance_euclidean(v,0x31313131) limit 30; +------+---------------+ | a | vec_totext(v) | +------+---------------+ | 1 | [2.57849e-9] | | 20 | [2.57849e-9] | | 11 | [2.57849e-9] | | 6 | [2.57849e-9] | | 7 | [2.57849e-9] | | 3 | [2.57849e-9] | | 5 | [2.57849e-9] | | 8 | [2.57849e-9] | | 9 | [2.57849e-9] | | 2 | [2.57849e-9] | | 4 | [2.57849e-9] | | 12 | [2.57849e-9] | | 19 | [2.57849e-9] | | 18 | [2.57849e-9] | | 17 | [2.57849e-9] | | 15 | [2.57849e-9] | | 14 | [2.57849e-9] | | 13 | [2.57849e-9] | | 10 | [2.57849e-9] | +------+---------------+ 19 rows in set (0.003 sec)