Bug #91670 READ ONLY on returned records
Submitted: 16 Jul 2018 21:03 Modified: 16 Aug 2018 21:19
Reporter: Matthew Jackman Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.10 OS:MacOS (macOS 10.13.x High Sierra x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[16 Jul 2018 21:03] Matthew Jackman
Quite often when result returns, I'm unable to edit record because it cannot identify a unique column. If I view the table's schema (by clicking on wrench icon) then re-run the same query, I'm now able to edit the records.

How to repeat:
Query a table with a WHERE condition. Do the same multiple times in other tabs. Even if column has primary key, occasionally "READ ONLY" is shown at bottom right of screen, and records cannot be altered. 

Suggested fix:
Review how "Read Only" lock / warning is performed.
[16 Jul 2018 21:05] Matthew Jackman
This is a seriously annoying bug :)
[16 Jul 2018 21:19] MySQL Verification Team
Thank you for the bug report. Please try development release version 8.0.11 rc and BTW which server version are you using?. Thanks.
[17 Aug 2018 1:00] Bugs System
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".