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:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.44 OS:Microsoft Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 32-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[7 Dec 2012 7:46] Jan Veres
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:
Installed display drivers: igdumd32.dll,igd10umd32.dll
Current user language: SlovenĨina (Slovensko)

How to repeat:
Change syntax
[12 Dec 2012 13:51] MySQL Verification Team
Thank you for the bug report.
[10 Jan 2013 18:51] Philip Olson
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.
[15 Nov 2020 10:50] Lucy Buckley
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.