Bug #51192 Alter Table - Foreign Key Name change not working

• Submitted: 15 Feb 2010 16:37
• Modified: 22 Mar 2010 17:24
• Reporter: Kristen Vannatter
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.15 oss beta rev 5053
• OS: Windows (Vista )
• Assigned to: Alexander Musienko
• CPU Architecture: Any
• Tags: foreign key

[15 Feb 2010 16:37] Kristen Vannatter

Description:
When attempting to alter table I was trying to change the foreign key name. I noticed that whether attempting to change it in either the Foreign Key tab or the Indexes tab neither updates the other. I also received an error message when trying to apply the change but was unable to find a solution. 

Change Foreign Key Name from: team -> fk_user_team
Error received: Type mismatch: expected type string, but got list
SQL: 

How to repeat:
Create table with foreign key reference. Alter table, attempt to change foreign key name under Foreign Key tab or Indexes tab. Manually change both and click apply.

[22 Mar 2010 13:50] Johannes Taxacher

fixed in repository

[22 Mar 2010 17:24] Tony Bedford

An entry has been added to the 5.2.17 changelog:

In the SQL Editor, if a foreign key name was changed using the Foreign Key tab or Indexes tab of the Alter Table dialog, the following error was generated:

Type mismatch: expected type string, but got list