mysql> SET GLOBAL TIDB_ENABLE_VECTOR_TYPE = ON;
Query OK, 0 rows affected (0.01 sec)


mysql> CREATE TABLE foo(val VECTOR);
Query OK, 0 rows affected (0.05 sec)


mysql> insert into foo values ('[1.1,2.2,3.3]');
Query OK, 1 row affected (0.01 sec)


mysql> select count(val) from foo;
+------------+
| count(val) |
+------------+
|          1 |
+------------+
1 row in set (0.00 sec)


mysql> insert into foo values ('[1.1,2.2,1.1]');
Query OK, 1 row affected (0.01 sec)


mysql> select Min(val) from foo;
+---------------+
| Min(val)      |
+---------------+
| [1.1,2.2,1.1] |
+---------------+
1 row in set (0.00 sec)


mysql> select Max(val) from foo;
+---------------+
| Max(val)      |
+---------------+
| [1.1,2.2,3.3] |
+---------------+
1 row in set (0.01 sec)


mysql> SELECT COUNT(DISTINCT val) FROM foo;
+---------------------+
| COUNT(DISTINCT val) |
+---------------------+
|                   2 |
+---------------------+
1 row in set (0.00 sec)


mysql> SELECT CAST(val AS CHAR) FROM foo;
+-------------------+
| CAST(val AS CHAR) |
+-------------------+
| [1.1,2.2,3.3]     |
| [1.1,2.2,1.1]     |
+-------------------+
2 rows in set (0.01 sec)


mysql> SELECT * FROM foo WHERE val > '[1.0, 2.0, 3.0]';
+---------------+
| val           |
+---------------+
| [1.1,2.2,3.3] |
| [1.1,2.2,1.1] |
+---------------+
2 rows in set (0.00 sec)


mysql> SELECT * FROM foo WHERE val < '[1.0, 2.0, 3.0]';
Empty set (0.00 sec)


mysql> SELECT * FROM foo WHERE val IS NULL;
Empty set (0.00 sec)


mysql> SELECT vec_dims(val) AS dims FROM foo;
+------+
| dims |
+------+
|    3 |
|    3 |
+------+
2 rows in set (0.01 sec)


mysql> INSERT INTO foo (val) VALUES (vec_from_text('[4.4, 5.5, 6.6]'));
Query OK, 1 row affected (0.01 sec)


mysql> SELECT vec_as_text(val) AS text_val FROM foo;
+---------------+
| text_val      |
+---------------+
| [1.1,2.2,3.3] |
| [1.1,2.2,1.1] |
| [4.4,5.5,6.6] |
+---------------+
3 rows in set (0.00 sec)