Bug #57849 Ignoring "Index Comment" field
Submitted: 29 Oct 2010 15:49 Modified: 26 Dec 2010 17:59
Reporter: Vadim Sadovsky Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.29, 5.2.31 OS:Windows
Assigned to: CPU Architecture:Any
Tags: comments, INDEX

[29 Oct 2010 15:49] Vadim Sadovsky 
Description:
"Index Comment" don't have an effect on "SQL Statement(s)" (and
not apply).

MySQL version: 5.0.45-community-nt
(the old version may be the cause)

How to repeat:
http://s.es4.ru/WorkbenchBug.png
[29 Oct 2010 16:24] Peter Laursen 
Can indexes have comment option in MySQL at all? 

http://dev.mysql.com/doc/refman/5.1/en/create-table.html
.. does not list such option. Only

index_type:
    USING {BTREE | HASH}

index_option:
    KEY_BLOCK_SIZE [=] value
  | index_type
  | WITH PARSER parser_name
[29 Oct 2010 16:44] Vadim Sadovsky 
But it's listed here http://dev.mysql.com/doc/refman/5.5/en/create-table.html
It would be nice to disable this field for older versions of MySQL.
[29 Oct 2010 17:41] Peter Laursen 
You are right.  I was not aware.  But I think index-level comments are buggy too, what I reported here: http://bugs.mysql.com/bug.php?id=57852
[26 Dec 2010 17:59] Valeriy Kravchuk 
Indeed, MySQL Workbench should disable this field when connected to server that does not support comments for indexes.
[8 Oct 2014 9:42] Mike Lischke 
In fact there's more wrong with that, as I reported here: http://bugs.mysql.com/bug.php?id=74263