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

Add support for ENUM column type

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.5.0.Beta1
    • 1.5.0.Alpha1
    • vitess-connector
    • None

      Vitess Connector doesn't support ENUM column type. It sends the index number instead of the ENUM value.

       

      Vitess 9.0.0 added better ENUM support to VStream, it adds the ENUM's definition in the FIELD event:

        fields {
          name: "size"
          type: ENUM
          table: "t1"
          org_table: "t1"
          database: "vt_test_sharded_keyspace"
          org_name: "size"
          column_length: 6
          charset: 33
          flags: 256
          column_type: "enum(\'m\',\'l\',\'xl\')"
        }
      

      The Vitess Connector can parse the column_type for the list of permitted values and store it in the in-memory schema of the table.

            kewei.shang kewei shang (Inactive)
            kewei.shang kewei shang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: