Bug #79661 alter table: default values disappear
Submitted: 16 Dec 2015 9:11 Modified: 13 May 2016 23:50
Reporter: Christian Hesse (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.6, 6.2.5, 6.3.4, 6.3.5 OS:Windows
Assigned to: CPU Architecture:Any

[16 Dec 2015 9:11] Christian Hesse 
Description:
I am suffering a Windows specific bug in WB...
This is my example table:

CREATE TABLE `t_nullErrorTest` (
  `id` int(11) NOT NULL,
  `test1` mediumtext NOT NULL,
  `test2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Open with "Alter table", then klick the column one by one. The default 'NULL' for test2 disappears.

This works perfectly fine with Linux version of WB.

How to repeat:
* create a table with default values
* alter table
* click columns

-> defaults values disappear
[16 Dec 2015 9:17] Marcin Marek 
Thank you for the bug report.
[16 Dec 2015 9:35] MySQL Verification Team 
Observed with 6.2.5, 6.3.4, 6.3.5 and 6.3.6 on Win7.
[13 May 2016 23:50] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

On Windows, the "DEFAULT NULL" value could unintentionally be removed from
the "Alter Table" window when clicking on it.

Thank you for the bug report.