Bug #49945 "start editing" grayed out if table contains special character
Submitted: 27 Dec 2009 13:20 Modified: 28 Dec 2009 9:50
Reporter: Bjorn Nuyttens Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.12 OS:Linux (Ubuntu 9.10)
Assigned to: CPU Architecture:Any
Tags: Dash, Minus, special character, start editing, tablename

[27 Dec 2009 13:20] Bjorn Nuyttens 
Description:
If a table's name contains a special character, you cannot edit the data.

Workaround: avoid special characters in table names by renaming the `special-table` to `special_table` :-)

How to repeat:
Create a table containing a special character like a dash/minus or plus sign.
CREATE TABLE `special-table` (
  `id_special` int(11) NOT NULL,
  `id_table` int(11) NOT NULL,
  PRIMARY KEY  (`id_special`,`id_table`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Execute the query SELECT * FROM `special-table`;
The "start editing" button is grayed out.
[27 Dec 2009 16:01] Valeriy Kravchuk 
According to http://www.mysql.com/support/eol-notice.html GUI Tools are no longer supported. Please, check MySQL Workbench 5.2.11.
[28 Dec 2009 9:50] Bjorn Nuyttens 
MySQL Workbench 5.2.11 (beta) does the job.