MySQL Bugs: #35462: Foreign Key with a $ is not visible

Bug #35462	Foreign Key with a $ is not visible
Submitted:	20 Mar 2008 15:38	Modified:	9 Jul 2009 12:53
Reporter:	Nelson Barreira	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12 - german	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	$, foreign key, not visible

Description:
Hi
If there is a Foreign Key with a $ in it we cant see the Foreign Key in the Edit Table Window.

How to repeat:
1. create table test2:
CREATE TABLE  `test2` (
  `auto_id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

2. create table test1 with a Foreign Key to test2.auto_id:
CREATE TABLE  `test1` (
  `auto_id` int(10) unsigned NOT NULL auto_increment,
  `fs_test` int(10) unsigned default NULL,
  PRIMARY KEY  (`auto_id`),
  KEY `Index_2` (`fs_test`),
  CONSTRAINT `test$blah` FOREIGN KEY (`fs_test`) REFERENCES `test2` (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

3. look at show create table test1 -> there is a Foreign Key
4. look at table test1 with the Edit Table Window -> there is no Foreign Key

PS: I tried to name the Foreign Key test$test but dont work -> Error. Is there a reason for that?

Thank you for the bug report. Verified as described.

Hi there
Is there something new about this bug?
Will this Bug be fixed in the near future?

Please try with actual version MySQL Query Browser 1.2.17.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".