Open
Description
MariaDB since 11.7 support a new VECTOR datatype
example :
CREATE TABLE `test_vector` (
id UUID NOT NULL DEFAULT UUID_v7() PRIMARY KEY,
content text DEFAULT NULL,
metadata JSON,
embedding vector(1536) NOT NULL,
collection_id uuid DEFAULT NULL,
VECTOR INDEX `idx_langchain_embedding_embedding_idx` (`embedding`)
);
this seems to causing issue when seeing table details: there is then no table field details, and in "Code Create", this display :
CREATE TABLE `test_vector` (
`id` UUID NOT NULL DEFAULT uuid_v7(),
`content` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`metadata` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`embedding` UNKNOWN NOT NULL,
`collection_id` UUID NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_langchain_embedding_embedding_idx` (`embedding`),
CONSTRAINT `metadata` CHECK (json_valid(`metadata`))
)
COLLATE='utf8mb4_bin'
ENGINE=InnoDB
;
Vector is set as "UNKNOWN"