Bug #80267 Workbench doens't detects Altering

• Submitted: 4 Feb 2016 12:39
• Modified: 18 May 2016 18:17
• Reporter: Marcel Haldemann
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.6
• OS: Windows (Microsoft Windows Server 2012 R2 Standard)
• CPU Architecture: Any
• Tags: WBBugReporter

[4 Feb 2016 12:39] Marcel Haldemann

Description:
If i alter a table (right click->"Alter Table...") and change something in the  "Default/Expression" Row From not having a value to a empty string '' (<NOTHING> to '') and hit Apply it says "No changes detected". But this acutally is a change. The workaround is to first set it to something (for example 'x') before then setting it to an empty string (<NOTHING> -> 'x' -> '')

How to repeat:
Create a table with a row of the type VARCHAR that doesn't have a default value.
Alter the table using the "Alter Table..." Function and try to change the Default Value to '' (empty string).

Suggested fix:
It should detect the change from NOTHING to '' (empty string) for the Default Value and Apply it accordingly

[4 Feb 2016 16:37] MySQL Verification Team

Thank you for the bug report.

[18 May 2016 18:17] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

The Alter Table functionality did not detect a default value change from
no default value to an empty string. In other words, adding a default
value of "" resulted in Workbench reporting "No changes detected".

Thank you for the bug report.

[18 Aug 2016 20:49] Georald Camposano

Just downloaded 6.3.7 and the problem still exists