Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-8157

Add support for MySQL vector datatype

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 3.0.0.CR1
    • None
    • mysql-connector
    • 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/

            Unassigned Unassigned
            jpechane Jiri Pechanec
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: