Bug #73079 Cell not refreshed after setting value to NULL
Submitted: 23 Jun 2014 8:25 Modified: 15 Sep 2014 23:00
Reporter: Georgi Sotirov Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.x, 6.2.x OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[23 Jun 2014 8:25] Georgi Sotirov
In the result set grid the cells are not refreshed after their value is set to NULL

How to repeat:
1. Open MySQL Workbench;
2. Connect to a server;
3. Open SQL editor;
4. Type a query that returns all the data from a table (i.e. select * from <table>). The table should have a primary key, so the result set is updateable;
5. Click with the right mouse button on a cell having a value different than NULL;
6. From the context menu chose "Set field(s) to NULL";

Actual result: The old value remains displayed into the cell.

Expected result: The cell value is cleared and the gray rectangle with text "NULL" is displayed in the upper left corner of the cell to indicate the lack of value.

Suggested fix:
The value of the cell should display "NULL".
[23 Jun 2014 15:47] MySQL Verification Team
Please click apply after step 6. Thanks.
[24 Jul 2014 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".
[24 Jul 2014 18:15] Georgi Sotirov
Thanks for the nice suggestion, but clicking "Apply" wasn't necessary in 6.0 and I believe it's a regression. When I enter a value in a cell I immediately see it (without clicking Apply), so I think it should work in the same way for NULL values.
[25 Aug 2014 7:17] Georgi Sotirov
I've just uploaded a screen capture video (see file wb60-set_null.avi in /support/incoming @ sftp.oracle.com:2021, but the file is also available from ftp://sotirov-bg.net/pub/contrib/mysql/workbench/wb60-set_null.avi), which demonstrates how this worked well in 6.0.9, so please fix this regression. It doesn't work in 6.2.x as well.
[25 Aug 2014 11:25] MySQL Verification Team
Thank you for the feedback.
[15 Sep 2014 23:00] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.2.4 release, and here's the changelog entry:

The "Set field(s) to NULL" result field context-menu option did not

Thank you for the bug report.