MySQL Bugs: #47069: Cannot edit via gui in Query Browser if table has 'join' as part of its name

Bug #47069	Cannot edit via gui in Query Browser if table has 'join' as part of its name
Submitted:	2 Sep 2009 15:27	Modified:	20 Oct 2009 6:03
Reporter:	Tom Melly	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12, 1.2.17	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	join table name

Description:
If a table has the string 'join' in any part of the table name, then you cannot edit the table via the 'edit' button in Query Browser.

This may be related to bug #36201

How to repeat:
Create the following table:
<pre>
DROP TABLE IF EXISTS `test01`.`xjoinx`;
CREATE TABLE  `test01`.`xjoinx` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `myvalue` varchar(45) NOT NULL,
  PRIMARY KEY  USING BTREE (`oid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
</pre>

Select it in Query Browser. Note that the 'edit' button is greyed out, and cannot be pressed.

Thank you for the problem report. Please, try to repeat with a newer version, 1.2.17, and inform about the results.

Bug still exists under 1.2.17

BTW it's worth noting that the behaviour only seems to affect the 'edit' button. Normal updates, etc. via sql statements in the sql window, or via a script, are not a problem.

Thank you for the bug report.

Many thanks for writing a bug report. We are on the way to implement full functionality of
MySQL Query Browser into MySQL Workbench. We won't fix this anymore.

Lots of functionalities of MySQL Query Browser are already implemented in Workbench 5.2
which will get GA soon.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/