Bug #64728 Add support for editing query results of a view
Submitted: 21 Mar 2012 19:56 Modified: 22 Apr 2012 6:43
Reporter: Dimitriy A Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.38 CE OS:Any
Assigned to: CPU Architecture:Any
Tags: Edit, editor, query results, VIEW

[21 Mar 2012 19:56] Dimitriy A 
Description:
Please add support for editing query results of a view. Currently there is a note saying that results are Read-only. The hover text says that "Table 'view_name' has no primary keys or unique non nullable columns defined. ...". Other SQL Editors such as DbVisualizer support this functionality and I can edit the results of the same view in that editor without any trouble.

How to repeat:
Run a query against a view which has joins.
Attempt to edit results.

Suggested fix:
Results of a view should be editable.
[22 Mar 2012 6:43] Valeriy Kravchuk 
If you are speaking about views with joins, I wonder how change to column(s) used in join conditions should be made. Can you, please, provide more detailed example of what exact behavior you request in this case?
[23 Apr 2012 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".