MySQL Bugs: #38932: '0' default values are dropped

Bug #38932	'0' default values are dropped
Submitted:	21 Aug 2008 9:56	Modified:	21 Aug 2008 11:09
Reporter:	Vincent Courcelle	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.0.24	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	0, DEFAULT, Drop, values

Description:
When entering a default value of "0" for a not null, double or int table field, the default value is lost when closing and then reopening the file.

The bug occurs when you put '0' or 0 in the default value column.

This cause further problems with the program running over the database (the column don't have default value...), causing the database software to be nearly unusable when a lot of affected tables...

How to repeat:
Create a new table schema with a new table, add an int field with default value '0', close and the reopen the program: the default value disappeard.

Well, I guess there is an error in my schema file because I can't actually set any default value to my fields...

The default value is saved but not restored on the opening of the file, doing this to every table, causing the schema to become invalid (grrrrrr I will have to check back all my tables once the bug will be repaired!!!!)

<value type="object" struct-name="db.mysql.Column" id="{71156825-9044-4AB5-A3A8-41D55C5A7147}" struct-checksum="0xd3ccec73">
                      <value type="int" key="autoIncrement">0</value>
                      <value type="string" key="characterSetName"></value>
                      <value _ptr_="0AE12C08" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
                      <value type="string" key="collationName"></value>
                      <value type="string" key="comment"></value>
                      <value type="string" key="datatypeExplicitParams"></value>
                      <value type="string" key="defaultValue">1234567</value>
                      <value type="int" key="defaultValueIsNull">0</value>
                      <value _ptr_="0AE12D88" type="list" content-type="string" key="flags"/>
                      <value type="int" key="isNotNull">1</value>
                      <value type="int" key="length">-1</value>
                      <value type="string" key="name">Amount</value>
                      <value type="string" key="oldName">Amount</value>
                      <link type="object" struct-name="db.mysql.Table" key="owner">{CE713114-BA9B-48FB-B2B8-F5BB2F424DEE}</link>
                      <value type="int" key="precision">11</value>
                      <value type="int" key="scale">2</value>
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.double</link>
                    </value>

The bug wasn't present in 5.0.23, going back to this version

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=38825