diff support for spatial columns and indexes #97
Description
As advertised, spatial columns and indexes are not yet supported:
2019-08-30 12:26:36 [WARN] Skipping table `location_tz`: unable to generate DDL due to use of unsupported features. Use --debug for more information.
2019-08-30 12:26:36 [DEBUG] --- Expected CREATE
2019-08-30 12:26:36 [DEBUG] +++ MySQL-actual SHOW CREATE
2019-08-30 12:26:36 [DEBUG] @@ -3 +3 @@
2019-08-30 12:26:36 [DEBUG] - `pt` point NOT NULL,
2019-08-30 12:26:36 [DEBUG] + `pt` point NOT NULL /*!80003 SRID 4326 */,
2019-08-30 12:26:36 [DEBUG] @@ -8 +8 @@
2019-08-30 12:26:36 [DEBUG] - KEY `ix_location_tz_pt` (`pt`(32))
2019-08-30 12:26:36 [DEBUG] + SPATIAL KEY `ix_location_tz_pt` (`pt`)
It seems like it might not be too difficult to add this. That main issues seem to be the SRID on the column, the SPATIAL keyword in front of the key, and whatever is going on with that (32) after the key column.