MySQL Bugs: #72969: Data type combo box in Export Data dialog showing 2 non-working spatial types

Bug #72969	Data type combo box in Export Data dialog showing 2 non-working spatial types
Submitted:	12 Jun 2014 1:09	Modified:	30 Jun 2014 22:42
Reporter:	Javier Treviño	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The Data Type combo box present in the Export Data dialog is currently showing 2 data types that are not recognized by the MySQL server which are Line and LinearRing.

These appear in the MySQL Server documentation's Geometry Class Hierarchy (http://dev.mysql.com/doc/refman/5.7/en/gis-geometry-class-hierarchy.html) but they are not listed in the OpenGIS Geometry Model (http://dev.mysql.com/doc/refman/5.7/en/opengis-geometry-model.html).

These 2 types must be verified with the MySQL Server team to check if they must be removed from the combo box.

How to repeat:
1. Open MySQL for Excel
2. Select a connection and a schema.
3. On a Excel worksheet, select some data suitable for exporting it to a new MySQL table.
4. Click on Export Excel Data.
5. Click on Advanced Options.
6. Make sure the Show All MySQL Data Types checkbox is checked.
7. Select any column, and on the Column Options, expand the Data Type combo box, note the Line and LinearRing types are there, select one of them.
8. Click on the little down arrow at the right of the Export button, select Create Table.
9. Click on Create Table.
10. Note the MySQL Server throws an error similar to the following:

ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LINE NOT NULL,
  `ring` LINEARRING NULL,
  PRIMARY KEY (`id`))
ENGINE = MyISAM' at line 3

Posted by developer:
 
On hold, verifying with the MySQL Server Spatial team to see if the Line and LinearRing types are not supported.

Posted by developer:
 
According to the MySQL Spatial team:
Line is LOGICAL/THEORETICAL subclass of a LineString mentioned in the OGC standard.
The LinearRing concept is used in SFA-CA to construct polygons.
Line is a name for a linear segment and may be represented as a LineString containing 2 points. LinearRing is a simple LineString where the first and the last Point are equal.

Line and LineaRing are not a part of the SFA-SQL nor SQL/MM-Spatial standards, thus not implemented in the MySQL Server.

Posted by developer:
 
Removed the Line and LinearRing types from the list of valid data types supported by the MySQL server, meaning the types do not appear anymore in the Data Type combo box located in the Export Data form and are not treated as valid if typed-in by the user.

Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

"Line" and "LinearRing" were removed from the list of valid data types, so
they no longer appear in the "Data Export" data type form.

Thank you for the bug report.