defaultValueNumeric="0" or defaultValue="0" is translated to 0.0
Description
Environment
postgresql, mysql
Activity
Show:
Nathan Voxland July 23, 2014 at 2:46 PM
Final fixes should be in 3.2.2
Nathan Voxland July 23, 2014 at 2:46 PM
Still some cases where this converts in 3.2.1. Fixed in 3.2.2
Nathan Voxland July 10, 2014 at 8:12 PM
Fixed.
Janning June 27, 2014 at 1:23 PM
I have the same problem. liquibase 3.2.0 and postgresql 9.3.4
<column name="VideoId" type="INT" defaultValue="0">
</column>
or
<column name="VideoId" type="INT" defaultValueNumeric="0">
</column>
translates in PostgeSQL to "VideoId" INT4 DEFAULT '0.0' and I get the following error:
ERROR: invalid input syntax for integer: "0.0"
It also translates to 0.0 in mysql, but there it's more liberal and doesn't give an error (although I think if I wanted to write 0.0 I would, and if I wrote 0 I meant 0)