MySQL Bugs: #73079: Cell not refreshed after setting value to NULL

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:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.1.x, 6.2.x	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
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".

Please click apply after step 6. Thanks.

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".

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.

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.

Thank you for the feedback.

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
function.

Thank you for the bug report.