MySQL Bugs: #80019: Default value NULL gets erased merely by clicking to a default value field

Bug #80019	Default value NULL gets erased merely by clicking to a default value field
Submitted:	17 Jan 2016 17:34	Modified:	18 Jan 2016 7:54
Reporter:	M S	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	6.3.6 Build 511 CE 64-bit	OS:	Windows (7 Professional)
Assigned to:		CPU Architecture:	Any
Tags:	default value NULL erased, null, NULL disappears

Description:
I've seen this issue many times, so I asume it affects all Workbench versions. The issue appears in Modeling part (Diagrams) as well as in Database view, creating and/or editing table (alter table).

How to repeat:
1. Create a table with a column that have a NULL value.
2. Edit table, using alter table or in Model, to see column structure.
3. Arbitrary click on various fields from id below, and notice how NULL value dissappears when clicking on it, before actually editing it!
4. In Model view, when clicking on "x" close button on a tab, the changes are saved, and NULL value is gone. In Alter Table view is the same, only one must save changes before.

Suggested fix:
Make "default value field" at alter table or editing table in Model view, immune (to not response to) to a mouse clicking, when not actually editing a field.

When there is a NULL value and one wants to delete a NULL value, one must actually enter the field end erase NULL characters, and save changes either clicking away from field or using a Enter key.

Test case with a column using NULL value

Attachment: fk-test-case-2.mwb (application/octet-stream, text), 6.12 KiB.

Hello M S!

Thank you for the report and test case.
Observed this with WB 6.3.6 on Win7.

Thanks,
Umesh

Thank you for your feedback, Umesh! Additionally I've discovered, that NULL value gets erased also by merely clicking anywhere on row, not only on "default value" field. So, clicking far left to the row with NULL value, e.g. selecting a row, causes NULL value to disappear. (Only sometimes I must first select row with ID or other, and than select the row with NULL value, so it's not always consistent.)

Best!

animated gif showing NULL value disappears by clicking on column rows

Attachment: mysql-bug-null-disappears.gif (image/gif, text), 84.49 KiB.