René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SLQC doesn't support vectors for MYSQL","articleBody":"### Version\r\n\r\n1.27.0\r\n\r\n### What happened?\r\n\r\nMysql 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.\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE t1(\r\n    id INT PRIMARY KEY auto_increment,\r\n    embedding VECTOR(4)\r\n);\r\n```\r\n\r\n### SQL queries\r\n\r\n```sql\r\nINSERT INTO t1(embedding) VALUES (STRING_TO_VECTOR('[0.1, 0.2, 0.3, 0.4]'));\r\n\r\nSELECT id FROM t1 ORDER BY DISTANCE(STRING_TO_VECTOR('[1.2, 3.4, 5.6]'), embedding, 'L2_squared') LIMIT 10;\r\n```\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\n_No response_\r\n\r\n### What operating system are you using?\r\n\r\n_No response_\r\n\r\n### What database engines are you using?\r\n\r\n_No response_\r\n\r\n### What type of code are you generating?\r\n\r\n_No response_","author":{"url":"https://github.com/mcgold1","@type":"Person","name":"mcgold1"},"datePublished":"2024-12-02T21:35:44.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3732/sqlc/issues/3732"}