MySQL Bugs: #21766: MySQL Administrator does not allow foreign key renames in Mac OS X

Bug #21766	MySQL Administrator does not allow foreign key renames in Mac OS X
Submitted:	22 Aug 2006 1:52	Modified:	19 Oct 2006 14:08
Reporter:	Morgan Tocker	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.11	OS:	MacOS (Mac OS X)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
Foreign key renames/creates have poor support for a 'Name'.

Creating new foreign keys result in the default name of "newfk".  Renaming a foreign key does not work at all, as it results in no change.

This is working on windows version 1.2.1 beta.

How to repeat:
Test case:

CREATE TABLE test.`foreign_key_test_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE test.`foreign_key_test_2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id2` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id2` (`id2`),
  CONSTRAINT `my_constraint` FOREIGN KEY (`id2`) REFERENCES `foreign_key_test_1` (`id`)
) ENGINE=InnoDB;

Go to Catalogs > Test >Double Click on foreign_key_test_2 > Click on Foreign Keys Tab > Click on My constraint.

Try and change the name to "constraint_new_name" and hit "apply".

The error comes back as "No modifications to be applied."

** second test **
delete the my_constraint, and add a new constraint that is identical, named "my_constraint".  You'll notice that only "newfk" is possible for a name when you Apply the changes.

Thank you for a problem report. Please, try to use newer version, 1.2.x for Mac OS X, from http://dev.mysql.com/downloads/gui-tools/5.0.html. Inform about the results.

The Mac OS X bundle was labelled incorrectly.  The current version is still 1.1.11.  I have verified this bug on Mac OS X (10.4.7, PowerPC).

Hi,

This is really an OS X specific bug. As a temporary workaround you can change focus from the text edit box to some other control (e.g. a combo) and then press Apply.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

hello first i'm a beginner in mysql!please help me how to add a foreign key to a table using MYSQL GUI Administrator!