SLQC doesn't support vectors for MYSQL

[mcgold1]

Version

1.27.0

What happened?

Mysql added vector columns in MySQL 9.0. When trying to use SQLC with a vector column in the parser doesn't recognize it and throws a syntax error.

Relevant log output

No response

Database schema

CREATE TABLE t1(
    id INT PRIMARY KEY auto_increment,
    embedding VECTOR(4)
);

SQL queries

INSERT INTO t1(embedding) VALUES (STRING_TO_VECTOR('[0.1, 0.2, 0.3, 0.4]'));

SELECT id FROM t1 ORDER BY DISTANCE(STRING_TO_VECTOR('[1.2, 3.4, 5.6]'), embedding, 'L2_squared') LIMIT 10;

Configuration

No response

Playground URL

No response

What operating system are you using?

No response

What database engines are you using?

No response

What type of code are you generating?

No response

[kyleconroy]

Could you please include an example schema and query? I'm not familiar with the new vector type.

[mcgold1]

@kyleconroy Added an example schema and a couple of query examples. Additionally here's the MySQL 9.1 vector function doc page which may come in handy: https://dev.mysql.com/doc/refman/9.1/en/vector-functions.html.