-
Enhancement
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
-
-
MySQL 9 intorduces support for vector datatype - VECTOR - https://dev.mysql.com/doc/refman/9.0/en/vector.html
This is an array of 4-byte FP numbers, roughly equivalent of PostgreSQL halfvec.
The change should
- Move io.debezium.connector.postgresql.data.vector.HalfVector into core library so it is shared between MySQL and PostgreSQL
- Rename HalfVector to FloatVector and Vector to DoubleVector together with schema names to make it universal for both databases
- Introduce support for VECTOR keyword in MySQL grammar
- Implement support in MySQL connector
Similar datatype will be added to MariaDB later - see https://mariadb.org/projects/mariadb-vector/