MySQL Bugs: #25778: If started from MySQL Administrator, tuples are not editable

Bug #25778	If started from MySQL Administrator, tuples are not editable
Submitted:	23 Jan 2007 11:50	Modified:	24 Jan 2007 11:34
Reporter:	Tim Salter	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.9rc	OS:	Windows (Windows XP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Edit, read-only, record

Description:
When started from MySQL Administrator by a right click on the table, mySQL query browser shows records that cannot be edited. See workround below.

How to repeat:
Start MySQL administrator, right click on a table,click on "Edit table data".
In the instance of MySQL Query Browser that comes up, the tuples are not editable.

Suggested fix:
Workround - remove the backquotes from the schema name, requery & the results become editable.

select * from `schema`.`table`
->  select * from schema.`table`

Thank you for a bug report. Verified just as described. Looks like QB is doing something wrong when checking for primary key in case database name is quoted.

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