Bug #38438 Warnings about ENUM default values
Submitted: 29 Jul 2008 19:51 Modified: 9 Jan 2015 16:01
Reporter: Vincent Courcelle Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.23 OS:Any
Assigned to: CPU Architecture:Any
Tags: DEFAULT, enum, warnings

[29 Jul 2008 19:51] Vincent Courcelle
Description:
When creating an ENUM field, the "Validate all" reports warnings for fields having a default value (even if this value correspond to a real value in the ENUM)

21:47:25 | Invalid default value ''DEFAULTVALUE'' for column `Table`.`Field`: .

How to repeat:
Create a field ENUM('A','B') with default value 'A', then execute the "Validate all" command.
[30 Jul 2008 3:45] Valeriy Kravchuk
Thank you for a problem report. Verified just as described.