Bug #34402 Mysql can't insert default Value in Enum fields
Submitted: 8 Feb 2008 6:13 Modified: 19 Apr 2008 9:34
Reporter: Prashant Borse Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Data Types Severity:S2 (Serious)
Version:5.0.22-standard OS:Linux
Assigned to: CPU Architecture:Any

[8 Feb 2008 6:13] Prashant Borse 
Description:
I am using hibernate3 as the ORM and mysql as the database. i have table having some columns of Enum datatype with default values. 

when i try to insert the record from User Interface of the aplication, 
It should insert default values in Enum columns if i left the UI fields empty.
But it inserts null except the default values into the Enum columns.

How to repeat:
try to add the record leaving enum field empty at UI and setting the default value at database, with huge application and thousands of records(arround a lakh) into database.
[8 Feb 2008 7:14] Sveta Smirnova 
Thank you for the report.

But version 5.0.22 is quite old. Additionally I can not repeat described behavior with test data. Please upgrade to current version 5.0.51a and if problem still exists try to provide repeatable test case.
[9 Mar 2008 0: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".
[19 Mar 2008 9:34] Susanne Ebrecht 
We still need to now if taking a newer version (MySQL 5.0.51a) will solve your problem.
[19 Apr 2008 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".