MySQL Bugs: #28693: Can't add/edit rows in tables containing the word "join"

Bug #28693	Can't add/edit rows in tables containing the word "join"
Submitted:	25 May 2007 21:43	Modified:	16 Feb 2009 10:20
Reporter:	Jeff Brewer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Edit, join, name, table

Description:
Query Browser will not let me edit or add rows to a table with the word "join" in the name.

There are two possible workarounds I can think of:

A) Rollback to a previous version of Query Browser (1.2.9 and 1.2.2 work).

B) Change the table name, add/edit, and change the name back.

How to repeat:
1) Create a table like the following:
DROP TABLE IF EXISTS `temp`.`ajoinb`;
CREATE TABLE  `temp`.`ajoinb` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2) Select all rows from the table:
SELECT * FROM ajoinb a;

3) Try to add a row through the interface, however this is the point where the typical interface GUI to do so (a grey row below the last row) is not present.

4) Change the name of the table by removing one of the four letters 'j', 'o', 'i',  or 'n' from the name.  For example, 'ajoib'.

5) Reselect rows from the renamed table
SELECT * FROM ajoib a;

6) Add and edit row functionality is now available.

Suggested fix:
Allow editing of tables with the word "join" in the name.

Thank you for the bug report.

There is an easier 'workaround'.
If you set the tablename in ` everyting works fine.

Example: SELECT * FROM `ajoinb` a

Version 1.2.14 also affected.

Bug submitted at 25 May 2007 23:43.

Query browser is dead?...

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/