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
    • 0
    • 0% 0%

      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: