Bug #89818 Ability to edit result set by double-clicking on field goes away
Submitted: 27 Feb 2018 5:55 Modified: 5 Mar 2018 13:01
Reporter: Gary Trachier Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.10 OS:Mac OS X (v10.12.6)
Assigned to: CPU Architecture:x86
Tags: double-click, Edit, Result Set, sql editor, workbench

[27 Feb 2018 5:55] Gary Trachier
When working in the SQL editor, it is usually possible to double-click on a field in the result grid, then edit that field.  At times, double-clicking on a field DOES NOT enable editing.  It is, however, possible to click the "Edit Current Row" button at the top of the result grid to edit the selected field.

How to repeat:
1) Open connection to a database
2) Execute: SELECT * FROM `mydatabase.mytable`;
3) Edit field(s) in one or more result records (result lines) by double-clicking on the field(s)
4) Choose Commit Result Edits from the Query menu
5) Click the Execute then Close buttons to execute the update query.

Now... Try to edit a field in the result grid by double-clicking on a field.  It will not enable editing in that field.  That is the bug.

A work-around at this point is to click the "Edit Current Row" button at the top of the result grid.

Now... If you close the current SQL editor tab/window, then repeat steps 1 through 5, it will work correctly again.

Suggested fix:
[5 Mar 2018 13:01] Chiranjeevi Battula
Hello Gary Trachier,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL workbench 6.3.10 version with MySQL 5.7.21 and 5.6.39 versions.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.