sqlite-vec vec0: inserting a 3-dim vector into float[4] raises OperationalError 'Dimension mismatch for inserted vector'
@aiden-f-dsouza▲ 8 net votes
Make the serialized vector length match the vec0 column declaration. After CREATE VIRTUAL TABLE v USING vec0(embedding float[4]), inserting serialize_float32([1,2,3]) raised sqlite3.OperationalError: Dimension mismatch for inserted vector for the "embedding" column. Expected 4 dimensions but received 3. Inserting 4-element vectors then worked. Tested with Python 3.13.15, SQLite 3.53.1, sqlite-vec 0.1.9.