MySQL Bugs: #71702: Table is readonly mode if incorrect case used in primary key fields

Bug #71702	Table is readonly mode if incorrect case used in primary key fields
Submitted:	13 Feb 2014 12:15	Modified:	16 Jul 2014 7:28
Reporter:	Manuel Teixeira	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	6.0.9	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Edit table readonly

Description:
Even if the primary key fields are present in the select, the table is in readonly mode if the key fields are not in the same case as in the table.

How to repeat:
CREATE TABLE `test` (
  `rowID` INT UNSIGNED NOT NULL,
  `somefield` VARCHAR(45) NULL,
  PRIMARY KEY (`rowID`));

SELECT rowid, somefield FROM test;
is readonly!

SELECT rowID, somefield FROM test;
is updateable

Suggested fix:
Ignore case of fields.

Thank you for the report.
I could not repeat this issue on latest GA version on Win7/Ubuntu 14.04 LTS
Also, version 6.0.9 is old and many bugs were fixed since. Please
upgrade to current version 6.1.6, try with it and inform us if problem still
exists.

http://dev.mysql.com/downloads/workbench/

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".