Bug #83195 | views' result grids are not editable | ||
---|---|---|---|
Submitted: | 28 Sep 2016 23:20 | Modified: | 29 Sep 2016 3:41 |
Reporter: | Paul Weiss | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
Version: | 6.3.7 CE build 1199 (64 bit) | OS: | Windows (Windows 10 Home) |
Assigned to: | CPU Architecture: | Any | |
Tags: | result grid, UPDATE, Views |
[28 Sep 2016 23:20]
Paul Weiss
[29 Sep 2016 1:28]
MySQL Verification Team
Thank you for the bug report. This is expected behavior according explained here: https://dev.mysql.com/doc/workbench/en/workbench-faq.html#faq-workbench-read-only Why do my query results sometimes say Read Only but other times I can edit data in the results grid? Data in the query results grid is only editable when the query results includes a primary key. For example, "SELECT type FROM food" will be read-only if "type" is not a primary key, but "SELECT id, type FROM food" will be editable when "id" is a primary key. Typically, "SELECT *" syntax is used in Workbench which often includes query results with a primary key. For additional information, hover over the "Read Only" icon to reveal a tooltip that explains why your result set is in read-only mode.
[29 Sep 2016 3:41]
Paul Weiss
The query results _do_ include the primary key of the base table.