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:
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.6 Build 511 CE 64-bit OS:Microsoft Windows (7 Professional)
Assigned to: CPU Architecture:Any
Tags: default value NULL erased, null, NULL disappears

[17 Jan 2016 17:34] M S
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.
[17 Jan 2016 17:36] M S
Test case with a column using NULL value

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

[18 Jan 2016 5:47] MySQL Verification Team
Hello M S!

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

[18 Jan 2016 7:54] M S
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.)

[18 Jan 2016 7:59] M S
animated gif showing NULL value disappears by clicking on column rows

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