MySQL Bugs: #67835: Problem with add comment to index

Bug #67835	Problem with add comment to index
Submitted:	7 Dec 2012 7:46	Modified:	10 Jan 2013 18:51
Reporter:	Jan Veres	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.44	OS:	Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 32-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When I can add the comment to index, Workbench give me error:
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 'ADD INDEX `CreatedBy` (`CreatedBy` ASC)' at line 3
SQL Statement:
ALTER TABLE `kwdata`.`deliverygroups` 
DROP INDEX `CreatedBy` 
, COMMENT 'For Foreign key' ADD INDEX `CreatedBy` (`CreatedBy` ASC)

Syntax is generated by Workbench. Table has InnoDB engine. Column has smallint format.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\veres\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 32-bit
CPU: 2x Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz, 2.0 GiB RAM
Active video adapter (0): Intel(R) Q45/Q43 Express Chipset (Microsoft Corporation - WDDM 1.1)
Installed video RAM: 781 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 8.15.10.1749
Installed display drivers: igdumd32.dll,igd10umd32.dll
Current user language: Slovenčina (Slovensko)

How to repeat:
Change syntax

Thank you for the bug report.

Fixed as of the upcoming MySQL Workbench 5.2.46 release, and here's the changelog entry:

  An SQL syntax error would be reported when a comment was added 
  to an "INDEX".

Thank you for the bug report.

Bug and all ornaments are fired for the removal process for the candidates. All the skills are empowered for the use of the https://topaustralianwriters.com/edubirdie-au-review/ for all passages. The team is inflicted on the top of the margin in the phase for the offered items for humans.