Bug #96488 WB 8.0 adds the keyword VISIBLE when creating an index on MySQL 5.6
Submitted: 9 Aug 2019 13:58 Modified: 12 Aug 2019 7:12
Reporter: Simon Vacker Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.17 OS:Windows
Assigned to: CPU Architecture:x86
Tags: INDEX, invisible, table, Visible, workbench

[9 Aug 2019 13:58] Simon Vacker 
Description:
When I create a new index on a table on my MySQL 5.6 server, Workbench 8.0.17 adds the keyword VISIBLE/INVISIBLE which doesn't work. This issue started with WB 8.0. Temporary workaround is to manually remove "VISIBLE"/"INVISIBLE" from the SQL generated before executing it.

SQL generated by WB 8.0:
ALTER TABLE `2019-08-09`.`example` 
ADD INDEX `blabla` (`description` ASC) VISIBLE;
;

How to repeat:
Alter table on a MySQL 5.6 server and try to add an index
[9 Aug 2019 16:30] MySQL Verification Team 
Thank you for the bug report. Could you please provide the sql script to create the original database and table. Thank you in advance.
[12 Aug 2019 7:12] Simon Vacker 
My mistake, I can't reproduce it now so I think it must have been while connected to a MariaDB 10.1 server.