Bug #56508 Defining Column to NN leaves Default as Null
Submitted: 2 Sep 2010 16:53 Modified: 14 Oct 2010 22:43
Reporter: Mike Frank Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.27 OS:Any
Assigned to: CPU Architecture:Any

[2 Sep 2010 16:53] Mike Frank
ALter a table and set a NN where default was NULL.
Apply will fail.

How to repeat:
See attached screen

Suggested fix:
If NN checkbox is selected then empty the default if its NULL
[2 Sep 2010 16:56] Mike Frank
NN and default of null shown with yellow hightights

Attachment: WB NN default9-2-2010 11-44-00 AM.pdf (application/pdf, text), 29.09 KiB.

[14 Sep 2010 22:43] Sveta Smirnova
Thank you for the report.

Have you tried to remove default NULL value after checking "not null" checkbox?
[14 Oct 2010 23:00] Bugs System
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".