MySQL Bugs: #27245: cannot edit tables with names starting from underscore

Bug #27245	cannot edit tables with names starting from underscore
Submitted:	18 Mar 2007 9:30	Modified:	27 Apr 2007 15:41
Reporter:	Janusz Wisniewski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (WinXP)
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
We cannot edit rows of tables with the leading underscore in the name.

Everything seems right in the "edit table" window, but not in "resultset".

Primary key column in "resultset" window appears as not the key, and the "edit" button is inactive.

There is nothing wrong in the table itself, as we can "fix" it simply by renaming database files at the OS level.

I have compared this with older version of Browser (1.1.20) and it does not exhibit this bug.

Server: MySQL 4.1.12 under Mandriva 2006

How to repeat:
user: root with all privileges on

CREATE TABLE  `test`.`sample` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `NOTE` char(20),
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;
CREATE TABLE  `test`.`_sample` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `NOTE` char(20),
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

We can edit the first table, but cannot edit the second.

Suggested fix:
We'd like to edit all tables, regardless of the names ;-)

Thank you for a bug report. Verified just as described.

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