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

Details

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

    Description

      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;

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users DBZ-507 Unified Geometry type support

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: