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

As a Debezium user, I would like MySQL Connector to support 'Spatial' data types

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 0.7.2
    • 0.5
    • mysql-connector
    • None

      Currently Debezium doesn't support 'Spatial' data types for MySQL Connector which are:

      • GEOMETRY.
      • POINT.
      • LINESTRING.
      • POLYGON

      Would be great to have the support for these types in the near future in the MySQL Connector.

      https://dev.mysql.com/doc/refman/5.7/en/spatial-datatypes.html

      Sample table definition:

      CREATE TABLE `polygon` (
  `polygon_id` int(10) unsigned NOT NULL,
  `type` tinyint(5) unsigned NOT NULL DEFAULT '1',
  `centroid` point DEFAULT NULL,
  `data` geometry NOT NULL,
  PRIMARY KEY (`polygon_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

          1.
          		 MySQL Connector should support 'LINESTRING' data type Sub-task Closed Major Unassigned
          2.
          		 MySQL Connector should support 'POLYGON' data type Sub-task Closed Major Unassigned

              Unassigned Unassigned
              omarsmak@gmail.com Omar Al-Safi (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: