Bug #40061 Impossible to change index name
Submitted: 15 Oct 2008 16:05 Modified: 19 Mar 2009 12:34
Reporter: moi meme Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.26 OS:Any
Assigned to: CPU Architecture:Any

[15 Oct 2008 16:05] moi meme 
Description:
When i go to the "Indexes" tab of a table, I edit the field "Index Name",
type enter,
and the old name come back !

How to repeat:
use my attached file
Try to change in the table "TSpecificRuleDataInList" the name of one of these two indexes:
"fk_TSpecificRule_has_TSpecificData_TSpecificRule"
"fk_TSpecificRule_has_TSpecificData_TSpecificData"
[15 Oct 2008 16:05] moi meme 
corrupted database

Attachment: bdd_spot_v4.mwb (application/octet-stream, text), 122.63 KiB.
[15 Oct 2008 18:03] Valeriy Kravchuk 
Verified just as described.
[31 Oct 2008 17:16] Johannes Taxacher 
in first case, this is expected behaviour because WB uses the virtual index type "FOREIGN" to create/maintain indexes used fore referenced columns.
but WB should not create invalid code (e.g. too long identifiers like in that case)
[19 Mar 2009 12:34] Susanne Ebrecht 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/
[19 Mar 2009 12:36] Susanne Ebrecht 
Sorry, for too long index names there is already another bug report.

We will close this.