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:Microsoft Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Edit, join, name, table

[25 May 2007 21:43] Jeff Brewer
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.
[25 May 2007 23:07] MySQL Verification Team
Thank you for the bug report.
[11 Jul 2007 9:29] Torsten Bausch
There is an easier 'workaround'.
If you set the tablename in ` everyting works fine.

Example: SELECT * FROM `ajoinb` a
[17 Nov 2008 9:38] Shoo Reek
Version 1.2.14 also affected.

Bug submitted at 25 May 2007 23:43.

Query browser is dead?...
[16 Feb 2009 10:20] Mike Lischke
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/