MySQL Bugs: #27059: Can not edit table with primary key

Bug #27059	Can not edit table with primary key
Submitted:	12 Mar 2007 21:08	Modified:	27 Apr 2007 15:41
Reporter:	Sveta Smirnova	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:		OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:
Is not possible to edit some tables with primary key using Edit button.

Problem occurs in Windows version of Query Browser. Mac version is not affected.

How to repeat:
1. Create table as described in hidden comment.
2. Double-click on table name to get SELECT * query in the Query Area.
3. Click "Execute" buttton.
4. "Edit" button disabled.

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, I'm having this issue with Query Browser v1.2.17 on winxp, but only on tables whose name starts with a number. Also, I don't remember seeing this problem on previous, still recent versions of Query Browser.

To reproduce it, create this table:

CREATE TABLE `00test` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `text` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then, running any of the following queries makes the Edit button to be grayed out.

SELECT * FROM 00test;
SELECT * FROM dbname.00test;

There is a workaround though, basically you'll just have to enclose the table name in backward apostrophes. Run this and the Edit button gets enabled again.

SELECT * FROM `00test`;

Still troublesome for some international keyboards that don't have that character on them.