Description:
Workbench 6.3.4.0 build 828 under OS X 10.9.5, but probably platform independent.
Server version: 5.6.21 MySQL Community Server (GPL)
MySQL Workbench does a case-sensitive comparison on a table's PRIMARY KEY column name to determine whether a query result should be editable.
So while these two queries return the same results
SELECT mypk, description FROM mytable;
SELECT MYPK, description FROM mytable;
if the canonical case of the primary key column is "MYPK" and not "mypk", then only the second query produces an editable result grid.
The check should be case-insensitive, or more properly it should probably test in a more direct way rather than going based on column name.
How to repeat:
DROP TABLE mytable;
CREATE TABLE mytable (MYPK VARCHAR(10), DESCRIPTION TINYTEXT, PRIMARY KEY (MYPK));
INSERT INTO mytable VALUES (1, "one");
SELECT mypk,description from mytable;
Table is readonly. Whereas:
DROP TABLE mytable;
CREATE TABLE mytable (MYPK VARCHAR(10), DESCRIPTION TINYTEXT, PRIMARY KEY (MYPK));
INSERT INTO mytable VALUES (1, "one");
SELECT MYPK,description from mytable;
Works fine.
