MySQL Bugs: #56161: ALTER TABLE: NOT NULL DEFAULT NULL issue + odd secondary create attempt

Bug #56161	ALTER TABLE: NOT NULL DEFAULT NULL issue + odd secondary create attempt
Submitted:	21 Aug 2010 2:14	Modified:	6 Feb 2013 21:09
Reporter:	Roel Van de Paar	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.26	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
As per video. 

Secondary create attempt seems like a significant issue also.

How to repeat:
As per video.

Workbench does not automatically remove (any) default-value.

The second issue is a result of the "fallback-code" that re-creates the table as it was before, in case the creation of the altered table fails and it has already been dropped. the error-message in this case has already been improved.

Closing old already fixed bug