Bug #4996 Problem with ALTER TABLE and DEFAULT NULL values

• Submitted: 11 Aug 2004 17:53
• Modified: 11 Aug 2004 18:26
• Reporter: [ name withheld ]
• Status: Won't fix
• Category: MySQLCC
• Severity: S3 (Non-critical)
• OS: Windows (Windows XP and Linux)
• Assigned to: Matthew Lord
• CPU Architecture: Any

[11 Aug 2004 17:53] [ name withheld ]

Description:
When trying to change a non-NULL default value (for a specified column) to NULL, mysqlcc simply keeps the non-NULL value as the default.

- This happened in both Windows and Linux versions of mysqlcc 0.9.4 beta.
- I had to manually do :
  "ALTER TABLE table_name MODIFY column_name type DEFAULT NULL;"
  otherwise the default value wouldn't change.
- The value could change if I changed it to a non-NULL value.
- The column was set to accept NULL values.
- The changes were said to be successful although they did not occur.

How to repeat:
Try to change a non-NULL default value (for a specified column) to NULL with mysqlcc.

Suggested fix:
Write :
ALTER TABLE table_name MODIFY column_name type DEFAULT NULL;
but this should be possible through the graphical interface.

[11 Aug 2004 18:26] Matthew Lord

Dear Sir,

We have just recently stopped active development on Control Center as it is being replaced by 
the new gui tools, Administrator and Query Browser.  We are only fixing critical bugs at this point.

Have you had a chance to use Administrator and or Query Browser?  We have native binaries for 
Windows and Linux.

Best Regards