Bug #74332 Type not show for spatial index
Submitted: 11 Oct 2014 12:02 Modified: 3 Feb 2015 5:19
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.2.2, 6.2.3 OS:Linux (Ubuntu 14.04.1 LTS)
Assigned to: Juan Rene Ramirez Monarrez CPU Architecture:Any
Tags: spatial, WBBugReporter

[11 Oct 2014 12:02] Daniël van Eeden 
Description:
Server version: 5.7.5-labs-dd.

> SHOW INDEXES FROM `geo`.`geo1`\G
*************************** 1. row ***************************
....
   Index_type: SPATIAL
....
*************************** 2. row ***************************
....
   Index_type: BTREE
....
2 rows in set (0.01 sec)

But workbench doesn't show the index type for the spatial index

How to repeat:
Create spatial index and then look at the index type in wb.
[11 Oct 2014 12:02] Daniël van Eeden 
screenshot

Attachment: wb_spatial.png (image/png, text), 18.49 KiB.
[13 Oct 2014 5:42] MySQL Verification Team 
Hello Daniël,

Thank you for the report and test case.

Thanks,
Umesh
[3 Feb 2015 5:19] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

MySQL Workbench did not show the index type for spatial indexes.

Thank you for the bug report.