Bug #76387 Result grid lost edit result if not press ENTER or TAB when focus lost
Submitted: 19 Mar 2015 10:25 Modified: 12 Feb 2020 20:57
Reporter: Liu Yan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.3.2 OS:Linux (Fedora release 21 (Twenty One))
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[19 Mar 2015 10:25] Liu Yan 
Description:
When editing field in the result grid, I must press ENTER or TAB to confirm this edit. Otherwise, if I move focus to the another field by double click another field, the edit of previous field will lost.

How to repeat:
1. Edit a field in result grid, but don't press ENTER or TAB
2. Use mouse to click/double-click another field
3. The edit result will lost

Suggested fix:
Keep the edit result when focus off
[19 Mar 2015 11:56] MySQL Verification Team 
Thank you for the bug report. I couldn't repeat this issue with the below table:

CREATE TABLE `x` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `col1` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------

in result grid I edit col1 then click in field id in another row and
the new value of col1 is preserved. Any clue how to repeat?. Thanks.
[20 Mar 2015 2:34] Liu Yan 
You can repeat this bug by click another field in same row.
See the video attachment below.
[20 Mar 2015 2:36] Liu Yan 
Screen Recorded Video to show how to repeat this bug

Attachment: mysql-workbench.mp4 (video/mp4, text), 56.86 KiB.
[20 Mar 2015 7:53] MySQL Verification Team 
Thank you for the feedback.
Repeatable on FC21( couldn't repeat this on Win7 with WB 6.3.264 build).

Thanks,
Umesh
[26 Jul 2015 10:33] Paul Weiss 
Problem not occurring for me on 6.3.4.0 on Microsoft Windows 7 Home Premium SP 1, 64-bit.
[12 Feb 2020 20:57] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.21 release, and here's the proposed changelog entry from the documentation team:

On Linux, edits made to values in the result grid were lost when using the
pointer device to move within the grid, rather than pressing the Enter or
Tab key to change the focus.

Thank you for the bug report.