Bug #84222 Tables can only be edited once
Submitted: 16 Dec 2016 1:29 Modified: 16 Dec 2016 10:54
Reporter: Joe Schmoe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.3.8 OS:Microsoft Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[16 Dec 2016 1:29] Joe Schmoe
Description:
After applying edits to a table in the Result Grid for a remote database, the Result Grid for that table becomes read-only. Reloading the table, or closing and re-opening the table, has no effect. The only workarounds are to quit MySQL Workbench, or to open a different table that hasn't become read-only and double-click on a cell, then return to the affected table.

How to repeat:
1. Open a table in a remote database (SELECT * FROM table)
2. In the Results Grid, edit the values in some of the fields, or add or delete rows
3. Click Apply and complete steps to apply the changes to the remote database
4. The Results Grid for this table now behaves as if the table is read-only; cells cannot be edited, and rows cannot be created or deleted

Workaround:
a. Open a different table in a separate tab
b. Double-click a cell in the Results Grid for the table opened in step a, to start editing the cell
c. Return to the Results Grid for the original table
d. The Results Grid is no longer read-only

Suggested fix:
The Results Grid should not enter a read-only state after clicking "Apply"
[16 Dec 2016 10:54] Miguel Solorzano
Thank you for the bug report. I couldn't repeat connected with remote MAC running server 5.7.16. The table was created as:

 CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `col` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

and the edited the column col.