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
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.27
• OS: Any
• CPU Architecture: Any

[2 Sep 2010 16:53] Mike Frank

Description:
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".